retrieving hierarchical data
i have a custom record that represents hierarchical data, a parent/child type relationship. eg. component 1 uses component 2 & 3, component 3 uses component 4, 5 & 6. in addition component 1 might have quantity 5 of component 2, and quantity 8 of component 3. Given a node in the hierarchy i want to be able to get all their…