U.M. (Mac OS)

10-2 FileMaker Pro User’s Guide
To establish a connection between files for lookups and relational
databases, you define a relationship, an expression that tells
FileMaker Pro how to match records in one file with records in another.
Then you choose the fields that contain the data you want to work with.
Note All files involved with lookups and relational databases must be
FileMaker Pro 3.0 or 4.0 files.
Understanding the terminology
Before you begin, you need to understand the following terms for
lookups and relational databases. These terms are illustrated in the
sections that follow.
Choose FileMaker Help Index from the or Help menu, and then type:
E relationships, understanding
This term Means
Master file For lookups, the file that contains the copied data. It’s the file the
lookup originates from and the file the data is copied to.
For relational databases, the file that accesses and displays data
from another file.
Related file For lookups, the file that contains the data to copy. It’s the file the
lookup goes to and the file the data is copied from.
For relational databases, the file that contains the data you want to
access and work with in the master file.
A related file and the master file can be the same file.
A lookup copies data from another file into
the current file, in a field that belongs to the
current file
In a relational database, data from another file is
displayed in the current file, in a field that belongs
onl
y
to the other file
Client ID
Route
R20
Oak-Bos
Client ID
Route
R20
Oak-Bos
Client ID
Route
R42
Oak-Lon
Client ID
Route
R42
Oak-Lon