I have 2 list:
Stockinformation (location, product, amount)
Stockrequest (location, product, status, department).
(there are more list, but they are lookup list for e.g. locations and product)
What I want to do here is that when someone request product x from location y, and the status is e.g 3 (processed), that the stock in the stocklist gets updated (reduced).
I created a workflow on the request list and set 2 variables (set location and set product). Now I want in the stock list a workflow that says:
If location = variable location and product = variable product Then "amount" - 1
Could someone put me in the right direction to solve this matter?