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?
(On an infant's shirt): Already smarter than Bush