Duplicate tables in relationship window?

A

Access

I have about 300 tables in my relationship view.
Because a number of tables are used in more than one "portions" of the db,
to make the view more comfortable, I duplicated these tables in the
relationship view, such as tbl1, tbl1_1 (_x is a suffix by access).That way
in one side I link to tbl1 and in another I link to tbl1_1. The question is:
is there any problem by using duplicate table views, aka in relationships,
RI etc???

Thanx in advance.
 
N

Nikos Yannacopoulos

I believe duplicates are just for display purposes, in fact behind the
scenes it is just the same to Access.

Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2013: Form problem in reading data tables; relationship one-to-one 0
Lookup fields referring to tbls w/o relationship 5
multiple instances of tables in relationship window 9
Establish relationship between tables using TWO fields 8
Dear Abby - I have a Relationship problem - so slow its un-usable 0
Duplicate Values in the index, primary key or relationship 4
Look up wizard in tables 1
Duplicate hashtags in OneNote 0

Top