Hi Hilmar,

The tree table is built from another table with a similar structure.

Thanks,

Pf

>>I need some help creating a little recursive routine. I have a table that i want to have look like this
>>
>>

>>department   parent       level
>> 1             --           1
>> 2              1           2
>> 3              1           2
>> 4              2           3
>> 5              2           3
>> 6              3           3
>> 7              3           3
>>
>>The table is created from the below tree.  But only the department and parent are filled in:
>>
>>
>>                          1
>>
>>                        /    \
>>                      2        3
>>                     / \      / \
>>                    4   5    6   7
>>
>>
>>

>>I believe I need some sort of recursive routine that will scan the table and fill in the level column based on the above tree.
>>
>>Any help greatly, greatly appreciated,
>>
>>Thanks,
>>
>>Perry
>
>How do you access the tree data, from which you want to create the table? Another table, with a different structure?