Relationships have “sides”

table on one side and table on many side

At this point, it helps to think of relationships has having “sides.” For example, one supplier can provide many assets, so the Suppliers table resides on the "one" side of the relationship, while the Assets table sits on the "many" side, and the picture shows this.

Next, remember this rule: To create a one-to-many relationship, you use the primary key from the table on the "one" side as a foreign key in the table on the "many" side, and you’ll see how to do that next.

The same rule applies to one-to-one and many-to-many relationships, but not in quite the same way, so we’ll look at those later in this course. For now, keep the idea of “sides” in mind, and the video in the next section will show you how to create a relationship.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.