Database Reference
In-Depth Information
4
With
Use existing Tables and Queries
selected, click
Next
.
5
Display the
Tables/Queries
list, and click
Table: Products
.
6
In the
Available Fields
list, double-click the
ProductName
,
CategoryID
,
Quantity-
PerUnit
,
UnitPrice
, and
UnitsInStock
fields to add them to the
Selected Fields
list.
Then click
Next
.
8
On the third page of the SubForm wizard, you specify how the main form and
subform are linked.
TIP
Because there is a relationship between the Products table and the Categories
table that is based on the CategoryID field, the wizard selects Choose From A List
and indicates the relationship it will use. If the wizard can't identify which fields are
related, it selects the Define My Own option and displays list boxes in which you can
specify which fields should be related.