In a one-to-many relationship, one record in a table can be associated with one or more records in another table. For example, each customer can have many sales orders.

What is an example of a one to many relationship?

Here are some other examples of one-to-many relationships: People-Addresses (Each person can live at one address, but each address can house one or more people.) Owners-Pets (Each pet has one owner, but each owner can have one or more pets.)

How do you know if a relationship is one-to-many?

A one-to-many relationship is created if only one of the related columns is a primary key or has a unique constraint. In the relationship window in Access, the primary key side of a one-to-many relationship is denoted by a number 1. The foreign key side of a relationship is denoted by an infinity symbol.