Where are additional copies of my database tables coming from?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a database using Access 2003. I connected my tables with 1 to
many relationships; when I select 'relationships' on the toolbar, the diagram
has additional copies of my tables; for example 'Genre' and 'Genre_1'. I
don't know where these tables are coming from; they are not available to view
as 'Tables' objects.
 
Don't worry about them: Access adds them to simplify the drawing of the
relationship diagram. Think of them as pointers to the actual tables.
 
access displays those for many reasons. one of the most common is, each
time you run the lookup wizard on a field in a table, access creates (or
re-creates) a relationship for the tables involved - even if the
relationship was already there. as doug pointed out, no need to be
concerned about them, but if you want to remove them from your diagram,
simply right click on the table you want to remove and choose the Hide
option.
 
Back
Top