U.M. (Windows)

Using data from related files 10-9
Understanding relationships
Whenever you want to use data from another file—either for a lookup or
in a relational database—you must first define a relationship from the
master file to the related file. A relationship is an expression that
includes the name of the match field in the master file, the related
filename, and the name of the match field in the related file.
After you define a relationship, you can choose its name from the
relationship drop-down list as you work in the master file. The
relationship drop-down list is in all dialog boxes where you can select
field names in related files. The following example shows the dialog box
used to export FileMaker Pro data.
Master file
Match field
Related file
Match field
Relationship
Relationship drop-down list
with the Customers
relationship selected
Choose fields in
the related file
List of fields to export
Field from the current file
Fields from a related file