Database Reference
In-Depth Information
Figure 14-8. The Specify Table dialog box lets you tell FileMaker what table to use when
you make a new table occurrence. You also get to give the new occurrence a name. When
you name a new table occurrence, the goal is to help you remember the source table for the
new table occurrence. The new TO's name is Expenses_Line Items. The “Expenses” part of
the name helps you remember that this occurrence of the Line Item table is attached to the
Expenses TO.
5.
Click the OK button
.
You're back on the layout.
Now it's time to add fields from your new table occurrence to the Expenses layout.
Adding Fields for New Table Occurrences
To put your new relationship to work, you add the Invoice ID, Description, Price Each,
Quantity, and Extended Price fields to your Expense layout. Here's how:
1.
In Layout mode, switch to the Expenses layout
.
Or you could go to the Expenses layout and then switch to Layout mode.
2.
Open the Field Picker. In the pop-up menu at the top, choose Expenses_Line
Items
.
The fields from the Line Items table appear. Remember, you'll get the exact same list
if you choose the plain Line Items TO, since it's the same table. But you may not see
the right data if you choose the wrong TO.
3.
From the list, choose the Invoice ID, Description, Price Each, Quantity, and Ex-
tended Price fields. Set the Drag Options to a row with labels on top and drag the
fields into the Expenses layout
.
