I'm new to ms access vba, i need to write a vba to explode the part lists in the bill of material.(multi level BOM) I've heard of recursive BOM query. but i don't really understand it well. the BOM table has the following three fields.
ParentID ChildID and QuantityPer. how do i go by solving the problem on hand. please help