Share this Page URL

Chapter 2. The Basics of Database Design > Principles of Relational Databases - Pg. 32

The Basics of Database Design 32 This query retrieves records from five tables. Notice that in each relationship, the fields used to join the tables are included in both tables in the relationship. For example, the Orders tables and the Customers table both include the field CustomerID. CustomerID is the primary key that identifies each record in the Customers table, and it is the foreign key in the Orders table, relating the records in that table with the records that have the same customer ID in the Cus- tomers table. The grid at the bottom of the Query Design window displays the field names, the