Phantom tables

[Kevin Bruce]

I've set up a table structure with all the correct one-to-many
relationships, etc., just as I've always done, but this time, whenever I
open the relationships window, there appear several 'phantom tables' with
the same names as some of the others but with an "_1" extension. What's
going on? Should I be worried? How do I correct this?

Thanks in advance.

_Kevin

 

[John Vinson]

I've set up a table structure with all the correct one-to-many
relationships, etc., just as I've always done, but this time, whenever I
open the relationships window, there appear several 'phantom tables' with
the same names as some of the others but with an "_1" extension. What's
going on? Should I be worried? How do I correct this?

These table icons (not really tables, just a second icon for each
table) usually appear when there are two or more distinct
relationships between a pair of tables. Once in a while there are two
legitimate but distinct relationships between a table pair (e.g. you
might have a table with an EmployeeID foreign key for Project Director
and for Lead Programmer); more commonly, these arise when you've been
caught by Access' misdesigned, misleading and annoying "Lookup
Wizard". A Lookup field in a table creates a relationship between the
main table and the lookup table, even if such a relationship already
exists.

If the extra relationships are in fact redundant, select the join line
in the relationships window (not the table icon but the line), delete
it, and then delete the unconnected table icon.