U.M. (Windows)

10-10 FileMaker Pro User’s Guide
Once a connection is established between two files, you then have
access to data in the related file in any of the following ways:
1 Define a lookup, to copy data from one related record for each record
in the master file (establishing a one-to-one correspondence between
data in the master file and data in the related file).
1 Place one or more related fields in a layout of the master file, to
display data from one related record for each record in the master file.
This establishes a one-to-one correspondence between data in the
master file and data in the related file.
1 Add a portal in a layout of the master file, and then place one or more
related fields in the portal to display data from more than one related
records for each record in the master file. This establishes a one-to-
many correspondence between data in the master file and data in the
related file.
Keep these points in mind:
1 To define a relationship for a lookup, see “Defining a relationship for
a lookup” on page 10-13. To define a relationship for a relational
database, see “Defining relationships for a relational database” on
page 10-21.
1 Each relationship involves only one master file and one related file;
however, you can define many relationships from a master file and
many relationships to a related file. The related file of one
relationship can be a master file for a different relationship.
1 You can define many relationships between the same two files. For
example, the relationships can specify different match fields.
1 The match fields for a relationship can have different names; what
determines that the relationship is established is that the fields have
matching values. Be sure the fields are the same type and are indexed;
otherwise, the relationship might not find the records you expect.
1 You can define a relationship from one file to the same file (a self-
join.) For example, use a self-join in a portal to display a subset of
data in the current file, like all the employees of each manager.
1 If the master file is protected with passwords, you must have the
master password to define relationships. (See “Defining passwords”
on page 7-10.)
Choose FileMaker Help Index from the Help menu, and then type:
E relationships, understanding
?