I get the concept of nested sets as presented in the examples. The problem I have is making the leap to a BOM where a given part can appear in multiple places.
partID
rightEdge
leftEdge
...
isn't going to work so what am I missing? I thought about having a table of parts with parent data and table that just has the nested sets. But, then I'm back to recursion to populate the sets table.
Greg
partID
rightEdge
leftEdge
...
isn't going to work so what am I missing? I thought about having a table of parts with parent data and table that just has the nested sets. But, then I'm back to recursion to populate the sets table.
Greg