Hierarchial solution needed

[harsha384]

Hi,

I have a table which includes parent ID and individual ID. I need to create hierarchial relation between for each node of the branch.

For example,

If 10 is the topmost parent in the branch,which has multiple child, like 20 and 30, then further 20 has 40,50,60 child. N again 40 has child called 80.

Now to trace the branch of 80,

the set will be (80,40,20,10) bottom to top.

How to create it?

attaching the diagram for further reference

[BHATT]

Hi Jason,

You are checking based on previous parent id.

Could you please explain if we dont know the hirerachy level between parent and child then how you will make the WF.

Thanks,

Bhatt