If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type,then the data type on the foreign key field must be set to AutoNumber._________________________

Question

Quizplus · Accepted Answer

The foreign key field in a one-to-many relationship does not need to be AutoNumber; it should match the data type of the primary key it references, but it typically is a Number data type (or equivalent) that can store the AutoNumber values from the "one" side.

If the Primary Key Field on the "One" Side of a One-To-Many