Access2010 making _1 tables in relationship chart?

ulieq

Registered User.
Local time
Today, 02:49
Joined
Dec 15, 2011
Messages
28
Do any of you know why Access (2010 here) is making duplicate tables then renaming them _1 in the relationship chart? These tables don't show in the table list. Thank you.
 
u,

You must have joined the table to itself.

If you drag the same table into the relationship window, it will act just like an
import and append the "1" to the table name.

Maybe the table wasn't visible when you dragged it in the second time.

Wayne
 
I don't think it is that, because I could just delete the relationships, but they still keep coming back.
 
You're probably using that "extra" table somewhere else in your database. You have dropped the table TWICE onto the Relationships window and joined it to some other table or to itself (like WayneRyan mentioned).
 

Users who are viewing this thread

Back
Top Bottom