Share this Page URL
Help

Chapter 2. The Basics of Database Design > One-to-Many Relationship - Pg. 37

The Basics of Database Design Here are the steps. View a one-to-many relationship 1. 37 On the RelationshipDemo form, click the One To Many button. You'll see the following set of records: 2. Notice that more than one order exists for each company listed. That's the "many" side of the one-to-many relationship. Each order number is related to a single customer, which is the "one" side of the relationship. On the View menu, click Design View. This query retrieves its records from two tables related by the CustomerID field. Look at the different symbols used at the ends of the lines that connect the tables. You can tell that a relationship is a one-to-many relationship because the line end attached to the "one" table is marked with a small 1 , and the line end attached to the "many" table is marked with an infinity symbol, as shown here: