Hi,
My Project Planning System has a hierarchy of Projects > Milestones > Tasks.
Project has a projectManagers field with a Many_To_One Cardinality with the sec$User, while the Task has an assignedTo field with the same cardinaity to secUsers.
I would like to have a table on the Projects Edit Screen that will list all the users I have assigned a task and what task that is and under what milestone. A tree table would be ideal but I am still struggling with that.
Roughly something like this:
User 1 - Milestone 1 - Task 1
------------------------------Task 4
------------------------------Task 5
------------Milestone 2 - Task 4
User 2 - Milestone 1 - Task 2
----------------------------- Task 3
User 3 - Milestone 2 - Task 1
------------------------------Task 2
----------------------------- Task 3