SELECT(Child Table[Photo],[Reff Column]=[_THISROW].[ID])
In order to make this work, there are 5 steps to be followed:
1. Add the Parent record
3. Add the Child record
5.Trigger the workflow (an action to change a Status column which will trigger it)
This way, an unlimited number of children records can be added and the workflow will be triggered manually when the Children records are all added.
The mistake that I have made:
I was adding the Parent record and before saving it, from the form view, I was adding the Children records (New in the nested table).
What I didn’t realize was that, even though saved first, the children record are not available until after the parent record is saved.
And since the workflow was on ADDS in the Parent table, the workflow was triggered too early.
Hope it helps!