User manual

138 | Working with related tables and files
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 Table A with a field in
Table B, or more complex. A more complex relationship definition will usually
return a narrower set of related records. Examples of complex relationships
include using multiple match fields on one or both sides of the relationship,
comparing match fields using non-equal relational operators, or using
calculated match fields.
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 in the Client ID field in the Clients table and the Client ID field
in the Phone Numbers table are the same.
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 clients database has two tables: Clients, which stores names and addresses,
and Phone Numbers, which stores phone numbers and types of phone
numbers, such as work, home, fax, and so on. The data is split between two
tables because a single client can have multiple phone numbers.
Match field Match field
φμπ10_υσερσ_γυιδε.βοοκ Παγε 138 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ