Multiples of the same table appear in the relationship

[Sandwich]

First timer. Having prob's all data tryng to figure this out. I have created a the tables and relationships, then modified them, i.e deleted fields, created new tables, deleted the old relationships and created new ones. This I have done five, six times, maybe a little more than that, wasn't counting. When I view the relationships I have multiples of the same table, i.e Customer_1, Customer_2, Customer_3 and so on. I delete all the tables except for table no:1. I save the relationships and exit. When I return to the relationships it's as if nothing has been saved. Same problem, multiples of the same table again. I am about to pull my hair. Where am I going wrong. Help!!!!!!

 

[Remou]

Do you have tables related to themselves or tables related to the same table twice? If so, your relationships map will show multiple copies of a table. This should not trouble you.

 

[dhookom]

Remou is correct. Also, when you state "deleted the old relationships" how are you doing this? Are you simply selecting the table and deleting it from the relationship window?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]