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/fr/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

Réaction

Était-ce utile?

Oui Non
Vous avez indiqué que ce sujet ne vous a pas été utile ...
Pouvez-vous SVP laisser un commentaire nous disant pourquoi? Merci!
Merci pour vos commentaires.

Laissez votre avis sur ce sujet.

SVP ne pas utiliser pour des questions de support technique.
Pour le support à la clientèle, SVP nous contacter ici

Valider