O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Many-to-Many Relationships

Many-to-many relationships are both more difficult to understand and more difficult to resolve than one-to-many relationships. Don't be frustrated if you need to reread this section a couple times before you understand how they work.

Again, I introduce the relationship type by using an example from the order-entry system. (I've slightly edited two tables you saw earlier in the chapter.) I then give you two detailed examples from the Classic TV database.

Order-Entry System

Let's say that you have an Orders table (see Table 3.10) and a Products table (see Table 3.11). Each row in the Orders table represents a single order; each row in the Products table represents a single product. (If you want a better idea of what these ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required