I have the following hierarchy of parent to child table relationships:
– Project Plan
— Project Task
---- Project Task Assignee
EDIT Each project task assignee is a relationship of one assignee to one task, and there are as many rows as there are assignees.
I would like to know if it is possible to 1 list each project assignee from each task that relates to a project in one single table, each only showing up once.
I then would like to be able to search that list and show the details of a project only if they are listed as an assignee in that project.
How should I be organizing the data, what formulas do I need to use?