Where did this table come from?

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

Slez via AccessMonster.com

I have a bit of a mystery to solve. I have a table called "Customer_1" that
looks to be a duplicate of the table "Customer" that keeps showing up when I
view the relationships. If I click on design view, it takes me to "Customer".
If I hide it and close the view, it shows up next time I open the
relationships window, even though I save changes. It does not show up in the
objects.

I don't know wher "Customer_1" came from, but sure would like to delete it.
Any suggestions?
Thanks!
 
Slez said:
I have a bit of a mystery to solve. I have a table called
"Customer_1" that looks to be a duplicate of the table "Customer"
that keeps showing up when I view the relationships. If I click on
design view, it takes me to "Customer". If I hide it and close the
view, it shows up next time I open the relationships window, even
though I save changes. It does not show up in the objects.

I don't know wher "Customer_1" came from, but sure would like to
delete it. Any suggestions?
Thanks!
Click to expand...

The table reationships window will create "twins"of tables that participate in
multiple relationships. Don't worry about it. It doesn't represent an actual
table. It's the same behavior you get if you add the same table more than once
to the query designer.
 
Back
Top