When linking a subform to a main form,which of the following statements is true?
A) The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table.
B) The linking fields are typically the foreign key in the "one" table and the primary key in the "many" table.
C) The linking fields are typically the primary key in the "one" table and the primary key in the "many" table.
D) The linking fields are typically the foreign key in the "one" table and the foreign key in the "many" table.

Question

Quizplus · Accepted Answer

The linking fields between a main form (representing the "one" side of a relationship) and a subform (representing the "many" side) are typically the primary key in the "one" table and the foreign key in the "many" table. This setup ensures referential integrity, allowing each record in the "many" table to be associated with a record in the "one" table.

When Linking a Subform to a Main Form,which of the Following