I'm newer to deluge and I've seen this question mentioned here before but nothing I have tried will work.
I have a application that contains two items at the moment.
List of Employees
List of Training for Employees
The form for submitting a training has a multi-select field that looks up the employee's names. We could have 20 people attend one training. As mentioned in other areas on the community - this results in the multi-select entries being combined into one cell on the report side. I need each Employee to end up with the data on a row for reporting.
Example
Table: Employees
John Doe
Jane Smith
Bob Jones
Table: Employee Training.
Doe, Smith & Jones attended
date of training 4.6.21
length of training 5 hours
Report Need
Row1: John Doe 4.6.21 5 hours
Row2: Jane Smith 4.6.21 5 hours
Row3: Bob Jones 4.6.21 5 hours