There is a link between both tables so that tasks can be related to projects.
What I’m trying to achieve is something like this:
The goal is to visualize all projects to see what tasks are coming up next, and if there are no tasks allocated to a project, that should prompt me to think about what needs to be done. So I’d like to see:
A list of all projects regardless of whether there are tasks linked or not
The related tasks “nested” under each project
Only the open tasks should be shown (anything with the “Complete” field checked should be filtered out)