Help

Working with related tables and files
F
ILEMAKER PRO HELP 378
About the types of relationships
When you join two tables using a relationship, you establish criteria that FileMaker Pro uses to
display or access related records.
Your criteria can be simple, such as matching a field in TableA with a field in TableB. A more
complex relationship definition will usually return a narrower set of related records. Examples of
complex relationships include using multiple
match fields, comparing match fields using non-equal
relational operators, or using calculated match fields.
Related topics
About the relationships graph
About match fields for relationships
Creating relationships
About single-criteria relationships
In a single-criteria relationship, data in one field is matched to data in another field.
For example, a record in either table is related to any record in the other table when the values
TextFieldA and TextFieldB are the same.
Using a single-criteria relationship
Use a single-criteria relationship when you want to relate two tables based on a single common
value, such as a serial number or an ID number. For example, a database has two tables:
• Customers, which stores names and addresses
• Contacts, which stores phone numbers, types of phones numbers (such as work, home,
fax, and so on), and email addresses
The data is split between two tables because a single customer can have multiple phone numbers
and email addresses.
The tables have these fields:
Table Field name Comment
Customers Customer ID Number field, auto-enter serial number; this will
be the match field in the Customers table
First Name Text field
Last Name Text field
Address1 Text field
City Text field
State Text field