Help

Table Of Contents

Working with related tables and files

ILEMAKER PRO HELP 381

The tables are related as follows:

Customer ID and Event Date are the match fields in the relationship between the Customers and

Catering Line Items tables. In the Customers table, the Customer ID field is set to auto-enter a serial

number, giving each record in the Customers table a unique ID number. The Event Date field is a

date field with no additional options. You enter the current date when equipment is rented, or enter

any previous date to display equipment the customer rented on that date.

In the Catering Line Items table, Customer ID and Event Date are number and date fields,

respectively, and are match fields in the relationship to the Customers table. Equipment ID is a

number field, and stores the ID of the equipment being rented. Records from this table are displayed

in a portal in the Customers table.

In the Edit Relationship dialog box, the Allow creation of records in this table via this

relationship option is enabled for the Catering Line Items table. This means that you can enter

rental information in an empty portal row, and FileMaker

Pro creates a related record for that rental.

Finally, a portal is added to the Catering Line Items table on the Customers layout.

To create a new related record, enter the current date in the Customers::Event Date field and an

equipment ID number in the portal on the Customers layout. Because Event Date is a match field

and the relationship allows the creation of related records in the Catering Line Items table, the value

in Customers::Event Date is automatically entered in the Catering Line Items::Event Date field.

To view rentals from a previous date, change the value in the Customers::Event Date field.

FileMaker

Pro displays all related records with the same customer ID and event date.