Share this Page URL

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

The Basics of Database Design 31 3. 4. 5. You can see the pattern of relationships among these tables. Customers place orders, so the Customers table is related to the Orders table. If you had only an Orders table, you would need to list the customer's name (and probably the shipping address, too) every time the customer placed an order. Orders include products--often more than one product--that can be ordered by more than one customer. To reflect this situation, the Orders table is related to the Order Details table, and the Order Details table is related to the Products table. Through the relationship between the Categories table and the Products table, each product is asso- ciated with a category. Finally, to associate a supplier with each product, the Suppliers and the Products table have a relationship. Close the Relationships window (click Yes if you want to preserve any changes you made to the layout in the window), and then click Forms in the Objects list in the Database window. In the Forms list, select the form named RelationshipDemo, and then click Open. Click the Get Records button. You'll see the set of records shown here: