Our goal is to manage the stocks of a production line. We have a table with the BOM of the products to be manufactured and a table with the flow rack stocks of each component. When a product is finished, we want to subtract the quantity of components used in the stock table from the BOM table (the quantity is indicated in the BOM table).
We are looking for a way to load an entire table onto an application. At the moment we can load a table row by row. Is there a way to load the whole table at once?
Thank you in advance for your help !