Appearing Relationship Tables

[LeizladNeb]

When I go to look at my relationships table after a bit of fiddling around, Access seems to have duplicated some tables, calling them, 'originalname_1' and 'originalname_2' etc.
I guess this is something to do with how i've set stuff up or to do with queries, but could someone let me know how to put an end to it, and why it might be happening. Its suprisingly frustrating.

Yours Ben Dalziel

 

[montrose]

Ben Dalziel, They are, indeed there because of your queries-Access will make these 'indirect relationships'. If you don't want to see them just click on the button "Show Direct Relationships". Montrose Learn what you can and share what you know.