|
A one-to-many relationship, often referred to as a
"master-detail" or "parent-child" relationship,
is the most usual relationship between two tables in a database.
Common scenarios include customer/purchase data,
patient/medical-record data, and student/course-result data. For
example, each customer is associated with at least one order record.
Valued customers have many order records involving significant sums
and often a user needs to view one in connection with the other. In a
one-to-many relationship, a record in Table A can have (none or one
or) more than one matching record in Table B, but for every record in
Table B there is exactly one record in Table A.
For example, say you have Orders
table and Order Details
table , where order number
is a common field in each. You can create a master-detail
relationship that will enable you to navigate through the Orders and
jump to Order Details that belong to current order only.
 |
