Share this Page URL

Chapter 2. The Basics of Database Design > Why Use More Than One Table? - Pg. 40

The Basics of Database Design 40 In the Query window, you can see how the linking table (Order Details) is used to relate orders and products. Both the Orders table and the Products table have a one-to-many relationship with the Order Details table. It is the Order Details table that forms the "many" side of both relationships. 4. Close the ManyToManyExample query, and then close the RelationshipDemo form.