Hi,
I'm looking for a query which ask the name of the group eg. "110-05" then read how the group is made (a table is made for each group composition) and tells me the warehouse situation. The are 2 warehouse tables raw and finished items used to assembly the final product.
For example I need 1 pc of 110.00.104 to mount a 110.05. So I go into the other table and i see I have 13 pcs of 110.00.104 that are ready (table "Magazzino") and 90 pcs that are 50% in the production line (raw material)
I attach a smaller version of the db.
At the end I'd like to get a table in which I have [Codice;Qnt_required;Qnt_available;Qnt_raw]