Hi Guys
I'm a novice access VBA programmer. I’m trying to write a nested
query
to explode the bill of material. But the BOM table has more than 20
levels. It’s really redundant and annoying to write all those nested
queries in access. my question is, how do I approach this problem to
solve it using VBA. I’ve seen so many vba codes online, but I don’t
seem to understand it well enough to apply it in my situation.
the fields in the BOM table are the Following (Sample).
an item can be a parent as well as a child
The point of the BOM explosion is to Show how many componenets are
required to be a salable Item
ParentItemNumber ChildItemNumber QuantityPer
-------------------------- ------------------------
-------------------
1 G1 1
1 G2 2
1 G3 1
9 1 1
thanks
Mike