2 tables same AutoNumber ID?

B

Bob

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

Larry Linson

Bob said:
Can 2 separate tables be linked with the same
AutoNumberID but different other fields?
Click to expand...

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
 
T

Tom Ellison

Dear Tom:

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

Tom Ellison
Microsoft Access MVP
 
T

Tom Wickerath

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
__________________________________________
 
T

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
 
J

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!
Click to expand...

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]
 
Top