Operation Manual

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.
• One of the fields from the main form must be the Primary key for its table. (Date
would have to be used.)
• 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.
Step 5: Arrange controls
A control in a form consists of two parts: label and field. This step in creating the form determines
where a control’s label and field are placed relative to each other. The four choices from left to right
are Columnar left, Columnar—Labels on top, As Data Sheet, and In Blocks - Labels Above.
1) Arrangement of the main form: Click the second icon (Columnar—Labels on top). The
labels will be placed above their field.
2) Arrangement of the sub form: Click the third icon (As Data Sheet). (The labels are column
headings and the field entries are in spreadsheet format.) Click Next.
Figure 220: Arrange controls
Step 6: Set data entry
Unless you have a need for any of these entries to be checked, accept the default settings. Click
Next.
234 | Getting Started with LibreOffice 5.0