Bill Of Material Calculations

[Harry]

Hello Board,

 

I'm trying to develop a BOM Report.

 

I have a table of Products_Completed. Each Product has a stock code and a timestamp of when it was finished.

 

I have a table of Products, related to Products_Completed through ::Stockcode.

 

I have a BOM_Products table that is list Line Items. There is a BOM__Parent_Stockcode field, a BOM_Component_Stockcode field, a BOM_Quantity field and a BOM_UOM field.

 

This is related to Products through ::Stockcode again.

 

I am trying to get a list that shows all the BOM_Component_Stockcodes and the quantities that were used.

 

How do i link this together? Should i start a layout based on the BOM table?