Can I Use AutoNumber Field In Multi-Table Link?

[David Portwood]

Is there any problem using the AutoNumber field as the primary key, and then
using this field to define a 1-M relationship between two tables?

I recall being warned against this. At the time, I was using another db app
(Paradox). Would this warning also apply to Access?

 

[Rick Brandt]

Is there any problem using the AutoNumber field as the primary key,
and then using this field to define a 1-M relationship between two
tables?
I recall being warned against this. At the time, I was using another
db app (Paradox). Would this warning also apply to Access?

No. Using an AutoNumber as the PK in the "one" table and as the foreign key in
the "many" table is perfectly fine.

 

[David Portwood]

What I was hoping to hear. Thank you.

No. Using an AutoNumber as the PK in the "one" table and as the foreign
key in the "many" table is perfectly fine.

 

[Rick Brandt]

What I was hoping to hear. Thank you.

Looking at my post again I should clarify that the foreign key in the many table
would not itself BE an AutoNumber, but rather a long integer. It would however
reference the AutoNumber in the other table.