User manual

72 FileMaker Pro User’s Guide
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.
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