How do I reference a cell from another table?
I come from the SQL server world and want to update the value of a field by subtracting the value of a field in another table. It is for an inventory app.
Each time a salesman makes a sale I want to update the inventory of that salesman by subtracting the amount sold.
This is the “idea” Set Salesman.Item1 =
Salesman.Item1 - Order.Item1
I already have a workflow in place the records the order, finds out the salesman, call actions to update multiple items. I can update the specific item, I just need to know how to reference item from the order to subtract that amount.