May 9, 201411 yr 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?
Create an account or sign in to comment