Access 2003 - Relationship editor bug???

[Noozer]

Didn't see an appropriate group, so I hope these two will do...

I'm setting up my table relationships is MS Access 2003. Some tables appear
multiple times (ie, "table", "table_1", "table_2"). When I save the
relationships, the diagram looks fine. When I then reopen the relationship
diagram, all the relationships to the table copies (ie "table_1", "table_2")
have moved over to the real table ("table").

Why is this happening? Is there a fix?

Thanks!

 

[Allen Browne]

That's the way it works.

You only need a 2nd copy of the table ("table_1") where you have multiple
different relations between a pair of tables (as distinct from a multi-field
relation.)