AutoNumber data field

[tikchye_oldLearner57]

hello community

Can anybody kindly explain to me this statement:

"In Access, user cannot use an AutoNumber data field to enforce referential
integrity between tables"

however

when I created two tables, and both tables I allow Access created the
Primary keys for me.

Thereafter, I use the 1st column, which is the Autonumber, I created a Link
between the two tables and I also able to Enforce Integrity ?

why is that so that I can use AutoNumber to enforce integrity ?

I am using Access 2003

thanks community

 

[Arno R]

hello community

Can anybody kindly explain to me this statement:

"In Access, user cannot use an AutoNumber data field to enforce referential
integrity between tables"

I guess this must be understood as:
You cannot use an Autonumber *at both sides* of the relation.

You definitively *can* use an autonumer (and a long integer at the other side) to enable RI.

Arno R