View Tasks for a Managers Team
I created a Tasks table initially in my app assigning tasks to a Assigned To field that was a List User Type (as there are occassions where I can have more than one assignee on a task). That worked...
Forum Discussion
This part does not make sense to me.
They also recommended a join table between department and Team Member for the data flow (but this does not entirely make sense to me as an employee can only be part of one department.
But it does make sense to have a join table called Resource Assignments between Tasks and Resources to be able to assign multiple staff to a Task. Then the Resource Assignment Join table will know the Department via a lookup from the Team member table.
They also recommended a join table between department and Team Member for the data flow (but this does not entirely make sense to me as an employee can only be part of one department.
But it does make sense to have a join table called Resource Assignments between Tasks and Resources to be able to assign multiple staff to a Task. Then the Resource Assignment Join table will know the Department via a lookup from the Team member table.
If you use create the department manger as a user field, you can use that field for an initial filter. The initial filters would be: Department manager is the current user
