User manual

Chapter 4 | Working with related tables and files 122
4. If your database contains more than one table, select the appropriate table from the Table list.
5. Select a text, number, date, time, timestamp, or container field from the list of existing fields, or
define a new one.
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.
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