When you drag and drop a foreign key onto a primary key,what does Microsoft Access assumes the relationship is?
A)1:1
B)M:M
C)1:M
D)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