Create a Subform (editing subform)

When working with relational data (related data stored in separate tables), you often need to view multiple tables on the same form. For example, you might want to see customer data from one table and information about customer orders from another table at the same time.
Subforms are a convenient tool for doing this (a subform is a form inserted in another form).
The primary form is called the main form. We sometimes refer to a form/subform combination as a master/detail form or a parent/child form.)

This article explains how to create one. See the steps below.


1. Open the form and go to design view (right-click on the form and select designing).
2. Click inside the form (click the frame of the form).
3. Select “Data frame (detail or page)” from the menu “Insert.”
4. When the Data Group Wizard is open,
select from “child table.foreign key” the table with the data you want to display on the subform,
enter the foreign key (the field in a relational table that matches the primary key column of another
table, this table is the primary’s form table),
enter the number of rows you want your subform to have,
select the fields that you want to include from this table and their captions,
and then click “create data group.”
5. Place the subform on the form where you want.
6. Exit designing and save changes.

For more help, please see http://www.youtube.com/watch?v=Xom4wf46OGA