I have two tables: "Employees" which containsa list of all of our employees and "Training" which contains a list of all of the training classes that the employee needs to complete. Both tables also an "EmployeeID" column.
I am building a datatable to show the list of employees and then a column for each of the 15 classes that they have either taken or completed, which is identified with a yes/no.
Since these are two seperate tables, I need a way to lookup the EmployeeID from the Training table into the EmployeeID within the Employee table. I have tried the below code but can't seem to get it working. Can anyone provide some guidance?
Note: on the Data Table I have added Training.EmployeeID, Training.Class1, Training.Class2, etc. On the Training.EmployeeID column I would like to rename this from EmployeeID to a lookup into the Employee table and RETURN the Employee.EmployeeName field.
Then you would have an outer gallery with the Items property of coltraining. In this gallery you would put a label with the Text property Lookup(Employee,EmployeeID =ThisItem.EmployeeID,EmployeeName) Then put a gallery inside of the first one with the Items property RestofData. In this subgallery you could have all of the training sessions attended by the employee in the outer gallery. I did something similar with Customers and Orders. It helps to set the fill property of the subgallery to a different color.