User manual

About relationships | 139
The tables have the following fields:
The Client ID field is the match field in the relationship between the two tables.
In the Clients table, the Client ID field is set to automatically enter a serial
number, giving each record in the Clients table a unique ID number. In the
Phone Numbers table, the Client ID is just a simple number field.
Because the relationship is defined to allow the creation of related records in
the Phone Numbers table, the Client ID number from a Clients record will be
automatically inserted in the Client ID field in the Phone Numbers table in each
new related record. This allows many records in the Phone Numbers table to
be related to a single record in the Clients table.
Users will be able to enter a phone number in an empty portal row, and
FileMaker Pro will automatically create a related record for that phone number.
Table Field name Comment
Clients Client ID Number field, auto-enter serial number.
Match field for the Clients table
First Name Text field
Last Name Text field
Address1 Text field
Address2 Text field
City Text field
State Text field
Phone Numbers Phone Number Text field
Phone Number Type Text field
Client ID Number field. Match field for the
Phone
Numbers table
φμπ10_υσερσ_γυιδε.βοοκ Παγε 139 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ