I have a table of Personas and a table of Grupos.
I have an intersection table Grupo Participantes that associates these two; it is a many to many relationship.
A Persona can be a member of 0, 1 or more Grupos, and a Grupo can have 0, 1 or more Personas.
For example, Nick and Jeff can both be participantes in the Tennis and Golf grupos.
I want to define an action to add a Persona to a specific group.
I want to add a row to Grupo Participantes.
On this new row, I want to set the Grupo ID based on a static value or expression.
I want to set the Persona ID to the value of _thisrow for the person that was in context when I click the action.
If I define 3 actions:
Add new row, Set the value of a column (Grupo ID), and Set the value of a column (Persona ID), how do I coordinate the two update column actions to update the row I just created?
I could not find documentation on how to set the values of the columns on the row I am adding.