One-to-Many Relationship - MS-Access
- One to many relationship:
- For each record in one table, there may be zero, one or many records
matching in a separate table. For example, a record may have an invoice
header table related to an invoice detail table. The invoice header
table has a primary key, invoice number. The invoice detail table will
use the invoice number for every record representing a detail of that
particular invoice. This is certainly the most common type of
relationship that may encounter.
