I want to show the employee a complete list of subtasks based on their allocations for that month.
What fields are in the subtasks table that would enable such distinction?
Subtasks contains subtaskID, subtask_title, taskID, task_title, projectID and project_title. There isn't anything in that table that I can grab to relate to an employee by allocations except projectID. That's the main problem. I have to go through the project relationship with allocations to get a list of subtasks.
1 of 1 people found this helpful
Could we walk through this? I am an employee. I understand I am related, through allocations (not sure what exactly is that, but it has a month attribute), to several projects. Each project has many subtasks. If I want a list of all the subtasks of all of my projects in this month, I need a chain of relationships like this:
Employees - [EmployeeID and Month] - Allocations - [ProjectID] - Subtasks
Employees - [employeeID, month, year] -> Allocations - [projectD] -> Subtasks
These relationships exist as described. I can include a view of the ERD if that's helpful.
Got it! I had forgotten to add the direct relationship from allocations for staff to allocations for projects by project ID. My filtered value list now works. Thanks for helping me think about this properly. I had been banging my head on it for awhile.