LinkedIn
Twitter
I'm using an "execute an action on a set of rows" action from my "mixtures" table to copy a list of items from a template table called "temp_ingredients" to the child table of mixtures called "mix_ingredients". The template table is just a list of items with no association with the other tables. "Mixtures" and "Mix Ingredients" have a parent/child relationship.
From the Mixtures form, I have a button to run the action below but I don't have a way to pass the mixture_id to the child table through the copy_ingredients_mixture action. I tried to use the INPUT() function but it only seems to work with SETVALUE actions.
I have a multi-user app. Is there another way to copy records from an unrelated table to a child table with the correct parent_id?
A million thanks!
This is the action it's running:
