U.M. (Mac OS)

10-4 FileMaker Pro User’s Guide
When you type a value in the match field of the master file,
FileMaker Pro uses the relationship to find the first record in the related
file whose match field contains a matching value. Next, it copies the
value from the lookup source field into the lookup destination field,
where the value is then stored. Data that’s copied into the master file
doesn’t change when the value in the related file changes, unless the
match field in the master file is changed. In that case, the lookup will be
performed again.
After a value is copied into the lookup destination field, you can edit,
replace, or delete it like any other value. You can also update data in the
master file to match data that changed in the related file. (See “Updating
lookup values” on page 10-14.)
Keep these points in mind:
1 When the same value exists in more than one match field in the related
file, FileMaker Pro copies data from only the first related record.
1 When you type data in the match field of the master file, you might
be asked to type a password for the related file.
1 To copy data into a second field that uses the same match fields—for
example, to copy a name and telephone number based on a matching
client identification number—define a lookup for the second field,
and use the same relationship as the first field.
Client ID
Name
Phone
City
C235
Durand
42.83.91.04
Paris
Client ID
Name
Phone
City
C100
Burke
408-555-3456
San Jose
Client ID
Name
C200
Turkoglu
Client ID
Name
Phone
City
C200
Turkoglu
123-45-67
Istanbul
Lookup destination field
Master file
Match fields for the relationship
Related file
Lookup source field