- 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.
