Adding Power to Your Database - FileMaker Pro 13: The Missing Manual - page 177

3. From the “Show related records from” pop-up menu, choose Payment .
This is the Payment table occurrence you saw when you hooked up the Lease Agree-
ment and Payment tables in the Relationships graph ( Creating a Relationship Between
Two Table Occurrences ) .
4. Turn on “Show vertical scroll bar.”
A scrollbar lets you see more related records in a smaller space.
5. Turn on “Allow deletion of portal records” and then click OK .
The “Add Fields to Portal” window appears. When the Allow deletion option is
turned off , you can't delete Payment records using the portal and the regular Delete
command.
6. From the list of available fields on the left, select and move the Date Paid, Pay-
ment Amount, and agreementID fields .
Each field appears in the list on the right as you move it. It isn't necessary to add a re-
lated table's key field to a portal. In the real world, you don't usually want to see that
data. But while you're learning about portals and relationships, it's very helpful to dis-
play the key field so you can see how portals work.
TIP
Pay attention to the way the field name appears in the available fields list. You're seeing the
parts of a fully qualified field name . That is, the field is represented by its table name, fol-
lowed by a pair of colons and then the field name itself. It's kind of like you being called by
both your first and last names. This nomenclature helps you and FileMaker keep the Lease
Agreement and the Payment tables' agreementID fields straight.
7. Click OK .
FileMaker adjusts the portal object to show the number of rows you specified, and the related
fields you selected in the previous step appear in the portal ( Figure 4-11 ) .