User manual

80 FileMaker Pro User’s Guide
6. Click Options (or double-click the field name).
7. In the Options for Field dialog box, click the Auto-Enter tab, then
select
Looked-up value.
8. In the Lookup for Field dialog box, choose the table the lookup will
start with, and the table from which the value will be copied.
9. Select the field from which the lookup value will be copied.
10. Select options for the lookup.
11. Click OK.
12. Repeat steps 5-11 for each additional field for which you want to
define a lookup.
Editing lookups
To edit a lookup:
1. With the database open, choose File menu > Define > Database.
2. Click the Fields tab.
3. If your database contains more than one table, select the
appropriate table from the
Table list.
4. Double-click the lookup target field.
5. In the Options for Field dialog box, click the Auto-Enter tab.
6. Be sure Looked-up value is selected and click Specify.
To stop or suspend using a lookup, clear Looked-up value.
7. Make your changes.
8. Click OK.
For more information about creating and editing lookups, see Help.
Select To specify
Starting with table The table the lookup will use as its starting point in
the relationships graph
Lookup from related table The related table from which the related data will be
looked up
To Do this
Specify an action when values
in the match fields do not match
exactly
For If no exact match, then, select an option to
copy no value, copy the next lower or next
higher value that’s in the lookup source field,
or enter a fixed value to be used instead
Prevent null (empty) data in the
lookup source field from being
copied to the lookup target field
Select Don’t copy contents if empty. (Clear this
option to allow empty data to be copied.)
Select an option
for non-equal
data in match
fields
Select the
lookup
source field
Select the
lookup’s starting
point
When selected, prevents null data from being copied
Choose the
related table for
the lookup