william_wicker
Joined: 24 Mar 2006 Posts: 1 Location: Austin, TX
|
Posted: Fri Mar 24, 2006 10:40 pm Post subject: Recursive parent-child relations |
|
|
I am evaluating VirtualTree for one of my projects. I have a need for a recursive parent-child relationship (in my case, for a parts-list).
A simple example is:
Item 1
+- Item 2
+- Item 3
+- Item 3a
+- Item 3b
The data table for this might be
ItemID, Parent ID
Item1, (null)
Item2, Item1
Item3, Item1
Item3a, Item3
Item3b, Item3
The point here is that the nesting can be arbitrarily deep.
The recursive relation I just described is the classic case.
My specific case is more complex. For reasons beyond my control, I have three tables which recurse alternately. For example:
MasterA
+- Operation1
+- Component-a
+- Component-b
+- Operation2
+- Component-c
+- Component-d/MasterB
+- Operation3
+-Component-e
The basic patterns are:
- Masters have child operations
- Operations have child components
- Components can be Masters, have operations, and the recursion continues...
How should I approach this? _________________ William Wicker
ARM Automation |
|