Still struggling to figure out how to do calculations in my inventory app.
Short overview:
I have a database table with all parts in my inventory, these are intended for assembly of different products.
I have a table for each of the products where each row holds a specific part and its quantity, so its basically a “recipe” of the product.
I want to subtract all used parts from my inventory after a product has been put together.