User manual

74 | Creating databases
7. Determine the match fields for each table, and circle each one in your plan.
For more information, see “About match fields for relationships” on
page 137.
For example, in the Clients table you might want to assign each client a
unique, identifying number. You wouldn’t enter a client identification
number into the table unless you had a new client to add, so the existence of
a client number determines the existence of a record.
Client ID
Street
Postal Code
Client Name
City
Tour ID
Clients table
Routes table
Tour Name
Tours table
Phone
Route ID
Destination
Origin
Tour ID
Route ID
Destination
Tour Name
Origin
φμπ10_υσερσ_γυιδε.βοοκ Παγε 74 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ