Where did this table come from?

  • Thread starter Slez via AccessMonster.com
  • 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!
 
R

Rick Brandt

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!

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top