I have an access table with the fields id/parentid/level from which I want to create a tree menu that will diplay like this:
in brackets(parentid,level)
Item-A (-,1)
+item-B (A,2)
++item-G (B,3)
+item-C (A,2)
++item-D (C,3)
+++item-I (D,4)
++item-H (C,3)
+item-E (A,2)
+item-F (A,2)
I can get close by creating sibling and child recordsets and nested repeats but it never quite works as I really want it to as the family tree relationship must be paramount. Anybody got any ideas?
TIA
Struth
"Away from the actual ... everything is virtual"
in brackets(parentid,level)
Item-A (-,1)
+item-B (A,2)
++item-G (B,3)
+item-C (A,2)
++item-D (C,3)
+++item-I (D,4)
++item-H (C,3)
+item-E (A,2)
+item-F (A,2)
I can get close by creating sibling and child recordsets and nested repeats but it never quite works as I really want it to as the family tree relationship must be paramount. Anybody got any ideas?
TIA
Struth
"Away from the actual ... everything is virtual"