User manual

Chapter 4 | Working with related tables and files 97
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 > Manage > 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.
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