Microsoft Office Tutorials and References
In Depth Information
4. If necessary, click the Tables/Queries arrow, and then click Table: Customer .
Oren wants the form to include only the Customer ID, Company, First Name, Last
Name, Phone, and E-mail Address fields from the Customer table.
5. Click Customer ID in the Available Fields list box (if necessary), and then click the
button to move the field to the Selected Fields list box.
6. Repeat Step 5 for the Company , First Name , Last Name , Phone , and E-mail
The Customer ID field will appear in the main form, so you do not have to include it
in the subform. Otherwise, Oren wants the subform to include all the fields from
the Contract table.
7. Click the Tables/Queries arrow, scroll the list up, and then click Table: Contract .
The fields from the Contract table appear in the Available Fields list box. The
quickest way to add the fields you want to include is to move all the fields to the
Selected Fields list box, and then to remove the only field you don’t want to include
8. Click the
Note that the table name
(Contract) is included in
the Customer ID field
name to distinguish it from
the same field (Customer
ID) in the Customer table.
button to move all the fields in the Contract table to the Selected
Fields list box.
9. Click Contract.Customer ID in the Selected Fields list box, and then click the
button to move the field back to the Available Fields list box.
10. Click the Next button. The next Form Wizard dialog box opens. See Figure 4-17.
Choosing a format for the main form and subform
fields from the
primary table in
the main form
fields from the
related table in
option for a fo rm
with a subform
In this dialog box, the list box on the left shows the order in which you will view
the selected data: first by data from the primary Customer table, and then by data
from the related Contract table. The form will be displayed as shown on the right
side of the dialog box, with the fields from the Customer table at the top in the
main form, and the fields from the Contract table at the bottom in the subform.
The selected “Form with subform(s)” option button specifies a main form with a
subform. The Linked forms option creates a form structure in which only the main
form fields are displayed. A button with the subform’s name on it appears on the
main form; you can click this button to display the associated subform records.
The default options shown in Figure 4-17 are correct for creating a form with Cus-
tomer data in the main form and Contract data in the subform.