In Access,to create a relationship between one row of a table and an unlimited number of rows in another table,users should ________.
A)create a link between the primary key in one table to the primary 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)drag the primary key in one table to the foreign key in another table

Question

Quizplus · Accepted Answer

To create a relationship between one row of a table and an unlimited number of rows in another table, we need to create a One-to-Many relationship between the primary key in the "one" table (i.e., the primary key side) and the corresponding foreign key in the "many" table (i.e., the foreign key side). Therefore, we need to drag the primary key in one table to the foreign key in another table, which is represented by choice D.

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