This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

one-to-many relationship

An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table.

An example is the relationship between a Customers table and an Orders table, in which each customer can have many orders, but each order is related to only one customer.