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.