Data Director Implementation Guide

Back Next

Many:Many Child Relationships

For many:many relationships, the child record is related to the primary object through a relationship table.

The relationship table in a many-to-many child must contain two foreign keys.

IDD supports two types of many:many relationships. The following table describes the types of Many:Many child relationships:

Relationship	Description
Part Of	The child record belongs to the primary object. No other subject area should reference this child. When adding a child, both the relationship and child records are added. When editing a child, if another subject area references it, a copy of the child is created. The data referenced by the other child remains unchanged.
Reference	The child is another subject area. When adding a child, only a relationship record is added. The IDD application user must search for the subject area child to be related. To edit the child data, the subject area for that child must be opened. This child can be linked through a standard relationship Base Object or an HM relationship Base Object.