In Access,to create a relationship between one row of a table and an unlimited number of rows in another table,users should ________.
A) drag the primary key in one table to the foreign key in another table
B) create a link between the foreign keys of both the tables
C) drag the foreign key in one table to the primary key in another table
D) create a link between the primary key in one table to the primary key in another table

Question

Quizplus · Accepted Answer

To establish a one-to-many relationship in Access, you drag the primary key from one table to the foreign key in another table. This links one row in the first table to multiple rows in the second table.

In Access,to Create a Relationship Between One Row of a Table