U.M. (Windows)

10-4 FileMaker Pro User’s Guide
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