Create Group-Level Links

A group-level link defines a master-detail relationship between two datasets.

The following figure shows two datasets with a group-level link defined and the resulting XML data structure.

Description of the illustration xdo11g_dse_5a.gif

To create group-level links:

1. In the parent group, click Menu.
2. Click Create Group Link.
3. In the Create Group Link dialog, select the child group and click OK.
4. Click Menu and then click Edit Data Set to add the bind variables to your query.

   You must define a unique bind variable in the child query.

   An example is shown below.

   Data Set: DEPT	Data Set: EMP
   Select DEPT.DEPTNO as DEPTID, DEPT.DNAME as DNAME, DEPT.LOC as LOC from OE.DEPT DEPT	Select EMP.EMPNO as EMPNO, EMP.ENAME as ENAME, EMP.JOB as JOB, EMP.MGR as MGR, EMP.HIREDATE as HIREDATE, EMP.SAL as SAL, EMP.COMM as COMM, EMP.DEPTNO as DEPTNO from OE.EMP EMP where DEPTNO=:DEPTID