I have three tables:
Employee
namelinked column to their position
Positions
namelinked column to the department its in
Departments
name
Is there a way to create a grid view that groups the employees by departments?
So it would look something like thi...
I figured it out. For posterity and anyone else who might need it:
The way I solved it was to create a lookup field in the employee table that looked up the department in the linked positions table. This created a column directly in the employee that...
