I have a table which contains our Build of Material data. The data is set up with the following columns:
PARENT - COMPONENT - QTY
Our BoM Structures can have up to 10 levels.
I am trying to find a way to put together the BoM Structure in a query. I have not found many options for this, and am completely stumped with anything I have found.
I believe I have to figure a way to loop the query to run at least 10 times to pull all the potential components that would roll up through the BoM.
For instance, a parent item is made up of 10 components. Those 10 components could be made up of more components, and then on and on, up to 10 items.
Anyone have any experience with creating a multiple level Build of Material before and possibly point me in the right direction on how to attack this?
Hopefully this is a general enough description. Please let me know if I need to be more clear in my description and as always, thank you for any assistance you can provide!