Get Rid of Relationship Among "ID" fields


L

lecoughlin

I have several tables with an "ID"autonumber field. There is no
relationship between the ID in one table and the ID in another... I
use the autonumber just to determine the order records were added
in.

When I look at the relationship window, there is no tie among the "ID"
fields, but as I add the tables to make queries, it automatically ties
the ID fields. How can I get rid of this??

Thanks in advance.
 
Ad

Advertisements

D

Dirk Goldgar

I have several tables with an "ID"autonumber field. There is no
relationship between the ID in one table and the ID in another... I
use the autonumber just to determine the order records were added
in.

When I look at the relationship window, there is no tie among the "ID"
fields, but as I add the tables to make queries, it automatically ties
the ID fields. How can I get rid of this??

Thanks in advance.


In Access 2003, at least, this is controlled by the option "Enable AutoJoin"
on the Tables/Queries tab of the Tools -> Options... dialog.
 
Ad

Advertisements


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

Similar Threads


Top