Data Director Implementation Guide

10.3

Back Next

Grandchildren

When grandchildren are displayed in a table view, all grandchild records are displayed - not just those that are related to the selected child record. IDD has a configuration option that helps users understand the relationship of these grandchildren to the child.

A parentReference can be defined for the column that is the foreign key to the child record. This defines a label to be displayed in the grandchild record that contains data from the child.

In the example below, the foreign key column from the grandchild to the child is configured as a parent reference. This configures a label element with the set of columns to use for labels and the existsFormat. In this example, the label for the child record will be "<Phone Number>, (<Extension Number>)".

<many2ManyChild name="TestPhone" displayName="Test Phone" type="PART_OF" 
        uid="C_PHONE_CHILD4" mpcUid="C_MT_PHONE_CHILD4" defaultView="form">
            <layout columnsNum="3">
                <column columnUid="C_PHONE_CHILD4_REL|PHONE_ID" editStyle="FIELD"             
                    horizontalStyle="LARGE">
                    <parentReference>
                        <label existsFormat="{0} ({1})">
                            <column columnUid="C_PARTY_PHONE|PHONE_NUM"/>
                            <column columnUid="C_PARTY_PHONE|PHONE_EXT_NUM"/>
                        </label>
                    </parentReference>
                </column>
                <column … />
            </layout>
    </many2ManyChild>

Rename Saved Search

Table of Contents

Data Director Implementation Guide

Data Director Implementation Guide

Grandchildren

Grandchildren