Joining Two Existing Detail Sections

Open a report template that includes a subsection join in RDA.

1. Click the detail section that you want to perform as the child section.

2. From the Section menu, select Sub-Section Join.

3. On the Define Sub-Section Join form, under the Parent heading, select the Join To option.

4. In the Join To field, select the parent section to which you want to join the child.

5. Select a business view column from the Child columns list that is common with a business view column in the Parent columns and variables list.

   This is typically a common key field such as the address number field.

6. Select the same business view column from the Parent columns and variables list that you selected from the Child columns list.

7. Select as many fields from both the Child columns list and the Parent columns and variables list as you need to ensure that the correct records are matched in the report.

8. Select the Join only at level breaks defined in the parent section option as necessary, and click Finish.

   The child section resides within the parent section and includes a chain-link icon, indicating that it is joined to the parent section.