I want to create an action that will open a new related child table form using the “add row to another table using the values of this row”
Would I refer to the parent ID?
Essentially, it’s a customer parent table, I want to create a new child table populating the data with the fields from another table/row
Hope that makes sense…thanks!
Rod:
Would I refer to the parent ID?
If you want the child row to refer to the parent row, yes, you’d need to set a column in the child row to a reference to the parent; a reference to the parent is not added automatically.
Thanks!
There’s probably a few ways to do this but, would I run a lookup and show the ID then run the yes/no condition in the action?
If you are creating the child row from the parent row, the parent’s key column value is what you need to set the child row’s parent Ref column. For instance, if the child table has a column named Parent of type Ref, in the action for the parent row that adds the new child row, set Parent to [_THISROW].
I was just wondering about [_THISROW] Thanks!