• Click and drag the
Date
field in the Fuel table to the
Date
field
in the Vacations table. When you release the mouse button, a
connecting line forms between the two date fields (Figure 189).
Figure 189: Designation for a 1:n relationship
• Or, click the New Relation icon. This opens the Relations
window (Figure 190). Our two tables are listed in the
Tables
involved
section.
– In the
Fields involved
section, click the dropdown list
under the Fuel label.
Figure 190: Setting the relationship
between tables
– Select
Date
from the Fuel table list.
– Click in the cell to the right of this dropdown list. This opens a
dropdown list for the Vacations table.
– Select
Date
from the Vacations table list. It should now look
like Figure 191.
– Click OK.
Figure 191: Selected fields in a relationship
6) Modifying the
Update options
and
Delete options
section of the
Relation window.
Chapter 8 Getting Started with Base 255
Comments to this Manuals