I have a tasks table with a self-linking field that I use to define task predecessors. Is there a way when adding a predecessor to filter the options to show only those that relate to the relevant project/grouping?
The problem I am trying to solve is that there may be many tasks with the same name so sorting through them to find the correct one takes time. For example, in my task table I may have the following:
- Project 1:
- Task 1
- Task 2
- Project 2:
- Task 1
- Task 2
When selecting a predecessor for task 2 I have to wade through and find which Task 1 is the correct one for the project.
May be helpful to know: my tasks table has another linked record field that links to a projects table, therefore each task is tied to a project.