


Good morning,
I've been having a hard time since yesterday because I can't access the data that is in a one to many table in the database.
This is the case, I want to send a e-mail to an Employee, using data from one of the month and all the flights of that month.
So far I've not been able to find the data in a test preview as seen in the next images.
The code:
The result preview:
The data that I've found is the value of an external key (Unique Flight) in the employeeFlights Table.
Is it possible to access the full scope of data in the employeeFlights table to create a dynamic template that shows as many flights as there is entries in the table?
Note that the target mapping points to the Employees table not the Months table.
Solved! Go to Solution.