2 tables same AutoNumber ID?

[Bob]

Can 2 separate tables be linked with the same AutoNumberID but different
other fields?
Thanks for any help........Bob

 

[Guest]

No. If your intention is to create a 1:1 relationship, change one of the keys
to Number / Long Integer (but leave it set as a primary key).


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Larry Linson]

Can 2 separate tables be linked with the same
AutoNumberID but different other fields?

In one of the tables it will be AutoNumber, in the other, it will be just a
Long Integer containing the same value. (An AutoNumber Field is just a Long
Integer that is automatically incremented, or in the case of GUID,
created/maintained, by the DB Engine).

Larry Linson
Microsoft Access MVP

 

[Tom Ellison]

Dear Tom:

I'm not so sure. Couldn't we develop this as a "random join relationship?"

Tom Ellison
Microsoft Access MVP

 

[Guest]

I suppose, if one does not set either field as a primary key, and doesn't
care that the end result will be an Indeterminate relationship. And doesn't
care that a form built on two tables related in this way will act very
screwy, indeed.

By the way, when are you planning on stopping by and saying "Hello" in the
P_NG's?


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Ellison]

Dear Tom:

I still have a bit of paperwork to complete, NDA and such, then I'll be very
happy to come say hello. I have many friends among the group of MVPs, and
some new ones to meet!

Tom Ellison
Microsoft Access MVP

 

[John W. Vinson]

Dear Tom:

I still have a bit of paperwork to complete, NDA and such, then I'll be very
happy to come say hello. I have many friends among the group of MVPs, and
some new ones to meet!

You'll be welcome. The Access group is friendly, you may want to bring a flak
jacket for the Coffeehouse... <g>

John W. Vinson [MVP]