Where this duplicate table_1 came from?

[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

 

[Gary Miller]

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
________________________

 

[Ken Snell]

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.

 

[Emilio]

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

 

[Ken Snell]

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).