 |
|
Tutorial Home > Software > Office > Microsoft Access 2000 > Create Relationships between Tables Create Relationships between Tables Relationships define how the data in separate tables in a database are linked. For example, if you have a Customer table and an Order table, you will want to link customers to their orders. To link these tables, the Customer table must have a primary key set that uniquely identifies each record in the table. Then the primary key, for example, Cust_ID, of the Customer table is repeated in the Order table. By repeating the Cust_ID field in the Order table, each individual order is linked to a customer.
|
|
|
|
|
|||||||||||||||
| |||||||||||||||||||||
Gateway products are available through select retailers.
United States
(change country or region)