Corrupted relationships

T

Thanasis \(sch\)

Hi to everyone,

sometimes when i create a (one to many) relationship between 2 tables say A
and B and then i reopen the relationship window i notice that the
relationships get corrupted.What i see is douplicating tables (i.e A_1,B_1
etc.) inside the window.

Why does this happen? And how could this be corrected?

Thanks in Advance
Thanasis
 
D

Douglas J Steele

That doesn't mean the relationships are corrupted. Access just makes
multiple copies of the table in the window to avoid having lines cross. A_1
and B_1 are just references to the actual A and B tables.
 
T

Thanasis \(sch\)

Hi Doug,

thanks for reply.
How can i remove these uneccessary table references?

thanks
thanasis
 
D

Douglas J Steele

You can't, nor should you. They're NOT "unnecessary table references":
they're a graphic "shortcut" Access uses.
 
Top