User manual

152 | Working with related tables and files
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
φμπ10_υσερσ_γυιδε.βοοκ Παγε 152 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ