Getting Started Guide

Step 3: Add subform fields.
This step is exactly the same as step 1. The only difference is that not all of the fields
will be used in the subform.
1) Fuel is preselected under Tables or queries.
2) Use the >> button to move all the fields to the right.
3) Click the FuelID field to highlight it.
4) Use the < button to move the FuelID to the left.
5) Click Next.
Figure 190: Selecting fields of a subform
Step 4: Get joined fields.
This step is for tables or queries for which no relationship has been defined. Because
we have already defined the relationship, the wizard skips this step.
Note
It is possible to create a relationship between two tables that is based
upon more than one pair of fields. How to do that and why is discussed
in the Base Guide.
Caution
When selecting a pair of fields from two tables to use as a relationship,
they have to have the same field type. That is why we used the Date
field from both tables: both their field types are Date[DATE].
Whether a single pair of fields from two tables are chosen as the
relationship or two or more pairs are chosen, certain requirements must
be met for the form to work.
• No field from the subform can be the Primary key for its table. (FuelID
cannot be used.)
• Each pair of joined fields must have the same file type.
• One of the fields from the main form must be the Primary key for its
table. (Date would have to be used.)
Chapter 8 Getting Started with Base 217