Corrupted relationships

  • Thread starter Thread starter Thanasis \(sch\)
  • Start date Start date
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
 
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.
 
Hi Doug,

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

thanks
thanasis
 
You can't, nor should you. They're NOT "unnecessary table references":
they're a graphic "shortcut" Access uses.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disappeared Relationships; Can't Recreate 2
Object dependencies vs. relationships 4
Understanding Many-to-Many Relationship 4
relationships 1
relationship doesn't show up. Another view? 6
Can't change field length, there no relationships??? 5
So many relationships 16
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Back
Top