I have seen this question asked before but I’ve yet to find a how-to-ish explanation for how to actually update values using set columns to another table.
My sitch - i have a series of tables with items in them. A form uses choice components to allow the user the pick which items to include in as a new row in the “orders” table.
This works great but what I can’t do is to decrement the counter in the items table when i submit the row to my orders table.
I have related the items table <> orders table. I have lookups which list the item count in the orders table but I can’t CHANGE the value using a set column action since the only tables I can access are THIS ITEM and the user profile table.
I imagine other Gliders have ran into this so if there is a tutorial or other step by step way to do this I’d appreciate any help.
Thanks!