When you drag and drop a foreign key onto a primary key,Microsoft Access assumes that the relationship is a many-to-one (M:1).

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).If you perform the process in reverse (dragging and dropping the foreign key onto a primary key),the relationship will be reversed (M:1),which is not what you want.

When You Drag and Drop a Foreign Key onto a Primary