When you create a form containing data from two tables that have a one-to-many relationship, what type of form are you creating?
A) Blank form
B) Main form with a subform
C) Connected form
D) Tabular form

Question

Quizplus · Accepted Answer

When you have a one-to-many relationship between two tables, it means that for every record in the main table, there could be multiple matching records in the related table. Therefore, the best choice is to create a Main form with a subform. This will allow you to display the data from the main table in one part of the form and the related data from the sub-table in another part of the form. This is the most efficient way to display and input data for tables with a one-to-many relationship.

When You Create a Form Containing Data from Two Tables