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.

Share :

Back To Top

facebook main


Powered by Blogger.