User manual

About lookups | 151
After a value is copied into the lookup target field, you can edit, replace, or
delete it like any other value (because the lookup value belongs to the current
table). You can also update data in the current table to match data that changes
in the related table.
Creating lookups
To create a lookup:
1. Create a relationship for the lookup between the match field of the current
table and the match field of the related table. See
“Creating relationships”
on page 145.
2. With the database open, choose File menu > Manage > Database.
3. In the Manage Database dialog box, click the Fields tab.
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.
C235Client ID
Name
42.83.91.04Phone
ParisCity
C100Client ID
Name
555-3849Phone
VancouverCity
Current table
C200Client ID
SmithName
Records in related table
Relationship
Lookup target field Lookup source field
C200Client ID
SmithName
555-1234Phone
New YorkCity
φμπ10_υσερσ_γυιδε.βοοκ Παγε 151 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ