Operation Manual

Figure 213: Selecting fields of a sub form
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 | 229