Access Duplicating a Table

[Numpty]

I have a Table within a database named Venue. When I open the relationships window within Access (2000) it appears Access has duplicated the table. So I now have both a Venue and a Venue_1 table.

Can anyone give me a reason as to why this happens (presume something to do with normalisation?) and if it is likely to cause any problems with the database?

 

[neileg]

It is quite possible to have a table with a relationship to itself. I have an application where one table holds details of individuals and this refers back to itself to identify parents.

In your case, it appears that you have created such a self reference. This may or may not be appropriate. If it's not, then delete the relationship and Venue_1 from the relationship window.

 

[Numpty]

Cheers for the reply Neileg - not too far away I see - just don't mention the football pleease!

Anyway I've removed the duplicate table but as I didn't create it myself I'm not sure how it got there. I've removed it and manipulated some data and it hasn't returned so everything seems OK now.

 

[neileg]

Happy if I helped!

I was born in Sunderland, so I won't be mentioning the footy...

 

[Numpty]

Cheers for the reply. I deleted the table and the relationship from the relationships window. When I pressed the show all button they did not return. I've tested the database and there have been no problems at all since I presume this relationship was not valid.