Edit data in table when action is performed on another table

[jrsmith252]

Hi all.

I'm not sure whether this would be an action or an automation... I have created a form (table A) where the user can add values from table B, via an EnumList. When these values are added (and the form is saved/created), I would like to automatically edit the value in a corresponding column (in table B).

E.g. The form is a shopping basket and allows you to add grocery items (from a shopping list). When a shop is confirmed (by saving the form), the items in the shopping list become "checked" in the purchased column.

Thanks in advance, 

Jack