Relationships

[Jean]

Hope someone can help...I have 4 tables that I'm adding
to my relationships. I am having no problem relating
them and enforce referential integrity. However, each
time I return to that view, two of the tables have
duplicated themselves. Any ideas?? Thanks!

 

[John Vinson]

Hope someone can help...I have 4 tables that I'm adding
to my relationships. I am having no problem relating
them and enforce referential integrity. However, each
time I return to that view, two of the tables have
duplicated themselves. Any ideas?? Thanks!

This can happen if you have two different relationships between the
same pair of tables - for instance, because you've been tricked into
using Microsoft's misdesigned Lookup Wizard (which creates a
relationship even if one already exists and then conceals it).

If the two join lines are joining the same fields, simply select one
of them by clicking on the line (not the table icon, but the line
itself) and pressing the Delete key. Then you can delete the extra
table icon.

 

[Jean]

Yes! It worked! Thanks so much!!!

-----Original Message-----


This can happen if you have two different relationships between the
same pair of tables - for instance, because you've been tricked into
using Microsoft's misdesigned Lookup Wizard (which creates a
relationship even if one already exists and then conceals it).

If the two join lines are joining the same fields, simply select one
of them by clicking on the line (not the table icon, but the line
itself) and pressing the Delete key. Then you can delete the extra
table icon.


.