Create both Master and Details Records

[pmhungdao]

Hello,

I have Source Table (SourceID, Name), and SourceDetails Table (SourceDetailsID, SourceID, Details).

For each SourceID, I want to create (a set of) action to copy both Source/SourceDetails to Target (TargetID, Name) and TargetDetails (TargetDetailsID, TargetID, Details) tables.

I can create an action to add new rows from SourceDetails to TargetDetails, except for TargetID, it doesn’t exist at that time and we need the same TargetID for all the related SourceID. I am thinking of creating an action to add Target Table first, but don’t know how to pass the newly created TargetID to the next action.

Is there any way to overcome this problem?

Thanks.
Anh Han

[1minManager · Accepted solution]

pmhungdao:

but don’t know how to pass the newly created TargetID to the next action

Simply write some thing in another column in the Target table that the first action you created can look for.

ANY(Select(Target[TargetD],[Temp]="foo"))

Then make the last action in your sequence clear this column.

[Temp]=""

Simon@1minManager.com

[pmhungdao]

Work perfectly. Thank you very much!