Question

Which of the following is NOT true about multiple-table forms?

1) The main form will display the first table one record at a time just like a single-table form.
2) Access will automatically use the common field between the tables to create the form.
3) Before you can use two tables in a form, you must make sure there is a one-to-many relationship between the tables.
4) The subform will display "one" record in the one-to-many relationship.

Answer 1

The subform in a multiple-table form does not display only one record in a one-to-many relationship.

Step-by-step explanation:

The correct answer is 4) The subform will display "one" record in the one-to-many relationship. In a multiple-table form, the main form displays the records from the first table one at a time, just like a single-table form. Access automatically uses the common field between the tables to create the form, so option 2 is true. Before using two tables in a form, it's important to make sure there is a one-to-many relationship between the tables, so option 3 is also true. However, in a one-to-many relationship, the subform can display multiple records from the many side of the relationship, not just one record, so option 4 is not true.