Access table relationships

[JohnWard1947]

I'm using Access 2003. When I open the relationship window, one table linked to my main data table appears six times - the name is the same but with the addition of a number 1 -5. I can delete the five spare ones and drag a relationship to the main table but it keeps dissapearing.When I try to change the primary key in this table, it tells me that there is a relationship established which I must break - unfortunately, I can't see any relationship between the two tables in the relationship window. Any ideas?

John

 

[Pat Hartman]

In the relationships window, press the show all relationships button. To get rid of extraneous relationships, you need to delete the relationship first. Then you can get rid of the suffixed table.