Save Parent and Child in one Table

abdulgafhur_0-1643703728767.png

Hi Guys, May I know how can save these two records in another table  in one action!!?!!

Solved Solved
0 1 61
1 ACCEPTED SOLUTION

If you mean save columns from these two records into a single row in another table, then because you have the Parent/Child relationship, you only need to access the Child row.  The child row has access to the Parent which means it also has access to all of those columns.

So you just need to create an action to "add a row in another table using values from this row" based on your Child table.  The expressions to copy the value from both Child and Parent would be (new row column on the left):

Branch ID  = [Child Parent ID Column].[Branch ID]
Creator  = [Child Parent ID Column].[Creator]
Date Order = [Date Order]
Item ID = [Item ID]
...

 

View solution in original post

1 REPLY 1

If you mean save columns from these two records into a single row in another table, then because you have the Parent/Child relationship, you only need to access the Child row.  The child row has access to the Parent which means it also has access to all of those columns.

So you just need to create an action to "add a row in another table using values from this row" based on your Child table.  The expressions to copy the value from both Child and Parent would be (new row column on the left):

Branch ID  = [Child Parent ID Column].[Branch ID]
Creator  = [Child Parent ID Column].[Creator]
Date Order = [Date Order]
Item ID = [Item ID]
...

 

Top Labels in this Space