Hi ,
I am trying to create a hierarchical tree with 3 levels in forms 6i with the following code
SELECT -1 state, 1 lvl, 'DEPARTMENT' disp_val, NULL icn, NULL val
FROM DUAL
UNION ALL
SELECT -1 state, 2, dept_name, NULL, dept_name
FROM fm_department where NVL(dept_frz_flag,'N')='N'
UNION ALL
SELECT -1 state, 3, emp_name, NULL, emp_code
FROM pm_emp_key
my problem is how can i relate the level 3 to level 2 as there is a link for dept_code in emp_table(level 3) as emp_dept_code foriegn key which is the primary key in fm_department table.
I have created a hierachical tree item 2 levels are comming correctly but when i click on 3 it overlaps and nothing is visible can someone help me by giving some tips or even samples.
[EDITED by LF: fixed CODE tags]
[Updated on: Wed, 09 February 2011 01:19] by Moderator
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
