Page 25 of 29PREVNEXT

Table that data

Tables with a one-to-many relationship

Callout 1 One supplier ...
Callout 2 ... can supply more than one product ...
Callout 3 ... but each product has only one supplier.

In a one-to-many relationship, a record in one table relates to multiple records in a second table, but the records in the second table relate to only one record in the first table.

An example is a Suppliers table and a Products table. One supplier might be the only source of multiple products, all of which relate only to that supplier.

Page 25 of 29PREVNEXT