A One-to-Many (or Many-to-One) relationship between two tables refers to a link between a single record in the relating table linked to multiple records in the related table. The most common forms of the One-to-Many relationship are the Parent/Child relationship and the Master Data Record:“Transactional Record”:https://www.manula.com/manuals/ninoxus/ninoxus/1.0/da/topic/transactional-data-tables relationship. Examples of Many-to-One relationships include:

  1. The relationship of a single invoice to many line-items within the invoice
  2. The relationship of a single corporation to many employees who work at that corporation
  3. The relationship of a single weekly employee timecard to the many days reported on the timecard

A variety of One-to-Many relationships are represented in the images below.

For additional information regarding the construction of One-to-Many (Parent/Child) relationships, please refer to the How to Build Parent/Child Table Links section of this users manual.

Revision: 2
Last modified: 2019/03/21

Feedback

Var dette nyttigt?

Ja Nej
Du har angivet, at dette emne ikke var nyttigt for dig...
Efterlad venligst en kommentar og fortæl os hvorfor? Tak!
Tak for din feedback.

Giv din feedback på dette emne.

Undlad venligst at bruge denne til support spørgsmål.
For kundesupport bedes du kontakte os her.

Skriv kommentar