Access97 Relationship

  • Thread starter Thread starter katz
  • Start date Start date
K

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
 
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
Click to expand...

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]
 
Back
Top