Database Reference
In-Depth Information
field by selecting the Lookup & Relationship data type when you create the RepNum field in the Customer
table, as show in Figure E-14.
Fields in the
Customer table
Lookup & Relationship
data type for the ield
being created
379
Available data
types
FIGURE E-14
Creating a relationship using the Lookup & Relationship data type
When creating the lookup field, you will indicate that the lookup field will get its values from another
table, as shown in Figure E-15.
Select t
his option
to look up values
in another table
FIGURE E-15
Lookup Wizard dialog box
You must select the fields to be included in the lookup field, as shown in Figure E-16.
