User manual

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