Access97 Relationship

[katz]

Hello!

I found an interesting problem when I open the relationship window.
I see that the tables are doubling like 8 to 9 times, and lines
(relationship) across up and down for each table.
I deleted all the double tables, but when I close the window and open again,
they come back again.
Can any body please tell me the problem?
Thanks
Abe

 

[John Vinson]

Hello!

I found an interesting problem when I open the relationship window.
I see that the tables are doubling like 8 to 9 times, and lines
(relationship) across up and down for each table.
I deleted all the double tables, but when I close the window and open again,
they come back again.
Can any body please tell me the problem?
Thanks
Abe

My guess is that you have multiple relationships between the tables.
Access will create a second table icon in such a situation - it's not
really another table, just another image.

To delete an extra, unneeded Relationship, select the *line* joining
the two table icons (not the icon itself) and delete it. Then you'll
be able to delete the extra icons (or they may disappear on their
own).

John W. Vinson[MVP]