Where this duplicate table_1 came from?

  • Thread starter Thread starter Emilio
  • Start date Start date
E

Emilio

I just realized that there are 2 tables in my
Relationships that are duplicates (both end on "_1")
Anybody knows where they came from?

Thanks for any help,
Emilio
 
Emilio,

It sounds like those tables got dropped into the window 2
times. You should be able to delete them with no problem if
you didn't intend them to be there twice.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Those tables can be put there by ACCESS when you create and save a query
that is using multiple copies of a table in the query. Or those tables can
be put there when you create relationships between two tables where one
table has two fields that are foreign keys to the other table.
 
Thanks for your response.
I am reading the book "Queries for Mere Mortals" and that
is what prompt me to look at Relationships, something
that otherwise I have never look into for the last 2
years.

Now my question is, is this wrong?
Should I investigate all my queries and tried to correct
them, or is it harmless.

Thanks again,
Emilio
 
Wrong? not likely. If the table is there with no relationship showing, then
it's probably no problem to delete it. If the table shows a relationship,
investigate that relationship to determine if it's ok to delete it (based on
the design of your database).
 
Back
Top