Trouble with multiple graph occurrences and displaying data on one layout
Here's a representation of the relationships I have with my tables:
Projects --> Deliverables --> Employee-Deliverables --> Employees
| --> Tasks --> Employee-Tasks --> Employees2
(The Employee-Deliverables and Employee-Tasks tables are so that multiple Employees can be assigned to a Deliverable/Task).
What I'm trying to do is be able to assign Deliverables and Tasks to employees and be able to see what Deliverables/Tasks are assigned on the Employees records.
So far, I can assign Employees to Deliverables and Tasks without issue. The issue I have is displaying what Deliverables and Tasks an Employee is assigned to on the same layout.
The layout is currently set up to show records from the Employees table, so I have no issue showing what Deliverables they're assigned to, I just can't show the Tasks.
Any suggestions on how I can get the layout to also show Tasks properly?