I will try to explain what i need to accomplish
I have a little firm. I work with stone. I order new material every once in a while and i want to keep track of it. In table X i keep track of everything i get from supplier. (1 - type of stone, 2- dimensions, 3- quantity, 4- quantity that will change).
I take 1 stone to work on it (i choose stone id 1 - žgano with dimensions 180/200)
In the Y table i would then select id 1 (which will link to the stone i took to work on from table X) input the dimension of the new stone that remains to work on another project and it would deduct the value from the real quantity in table X.
I hope you understand now .
Ok so I have attached a workbook with example. The cells marked in yellow are the one that changed- The real quantity values were deducted based on entry in the table two.
Best regards
Bookmarks