Creating Multi-Table Forms
Forms can be created from more than one table using the Form Wizard or the Form Design view. Creating a form from fields that reside in more than one table allows you to enter data into more than one table using just the single form.
A very simple way to create a multi-table form is to add a subform to an existing form. For example, you might have a form that is based on a Customers table. If you would also like to be able to view and enter order information when you work with the Customers form, you can add an Orders subform to it. It is important that the tables used to create the two forms (the main form and the subform) are related tables.
Subform A form control that actually consists of an entire form based on another table or tables.
The easiest way to reate a subform is to actually drag an existing form onto another form in the Design view. The following steps describe how you do it:
Figure 21.6. The subform is dragged from the database window onto the Design view of the main form.
Figure 21.7. The subform becomes another control on the main form.
Figure 21.8 shows the main form and the subform in the Form view. The form can be used to view or enter data into two tables at once.
Figure 21.8. The composite form can be used to view and enter data into more than one table.