Hi All, I am new to Forms. I would like to create a hierarchical tree with Department number as a node and all the employees (only employee names) under that department as shown below: [-]Department - 10 KING JAMES ----- [-]Department - 20 MARY | | and so on... I have created a hierarchical tree 'HT_DEPTNO' under block 'BL_EMP'. I also created a Record Group 'RG_HTREE' with query as shown below: SELECT 1, LEVEL, E.ENAME, D.DEPTNO||' - '||D.DNAME DEPARTMENT, D.DEPTNO FROM EMP E, DEPT D WHERE E.DEPTNO = D.DEPTNO START WITH E.DEPTNO = 10 CONNECT BY PRIOR E.EMPNO=E.MGR I know that there is some problem with the query, but am not able to resolve it. Can anyone please help me with this? Thanks for your time and concern. Akshita.