duplicate tables

[spiritwater2004]

The main table of my database is duplicated automatically in the relationship window, why?

 

[PHV]

Have you defined a self-join ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[spiritwater2004]

No, I haven't. I have a main table which I will call tblMain for purposes of explanation. tblMain contains several foreign keys which are the primary keys in linked tables. When I open the relationship window, tbl Main is duplicated with a link to itself and to two of the linked tables. There are more than 20 tables, but only two of the "lookup" tables are causing a problem. I don't have a lookup query in the field of the tbl main so I don't know what the problem is. It has slowed the query process to a snail's pace!

 

[PHV]

Remove the 3 relations starting from the dup table and create the 2 missing relations from the main table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[spiritwater2004]

The valid relationships aren't missing, additional relationships and an additional table is created by the system. I've deleted them several times and each time they return. Of course it does not return when I delete the tables, but I need the tables.

Thanks any way! Anyone else have any ideas?