Data Director Implementation Guide

10.4

Back Next

Many:Many Grandchild Relationships

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

IDD supports two kinds of many:many relationships: If the child is a many:many, the foreign key can be either to the (see the data model examples below):

Child record

Relationships record.

The following table describes the types of many:many grandchild relationships:

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