In a one-to-many relationship (1:M),a primary key may appear many times as a foreign key,and a foreign key must appear once and only once as a primary key.

Question

Quizplus · Accepted Answer

When you drag and drop a primary key onto a foreign key,Microsoft Access assumes that the relationship is one-to-many (1:M).That is,a primary key may appear many times as a foreign key,and a foreign key must appear once and only once as a primary key.

In a One-To-Many Relationship (1:M),a Primary Key May Appear Many