I am trying to set up a basic template for managing about 20 small construction projects. I have a table with records for each project and a separate table for all the various tasks that could apply to each project. I can't figure out how to link the various tasks to MULTIPLE projects while also tracking the status of the task within each separate project. Below is a simple example (in reality I have a list of ~50 tasks) of the way I'd like to be able to track tasks in EACH project.
Project A tasks:
-solicit bids (complete)
-draft contract (in process)
-hire sub (on hold)
Project B tasks:
-solicit bids (in process)
-draft contract (on hold)
-hire sub (on hold)
Thanks in advance!