Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Who Me Too'd this topic

Avatar

Level 2

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.Adobe problem.JPG

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:

Adobe problem code.JPG

The result preview:

Adobe problem output.JPG

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.

Who Me Too'd this topic