I’m looking for advice on how to track who has the next step in a project. For instance, I have many projects, linked to my tasks (one table for projects, one for tasks). I am looking for advice for ways to track who has the next step, when that step is due or promised.
Right now, I have the following columns on my projects and on my tasks:
Owner, Due Date, status(planned, active, waiting, done).
But, I am running into the issue where I have a hard time seeing when something is due vs when it is promised to me. Is the answer to make a column for due date, another column for promised date, and then a column for who has next step, and who is owning the task?
Thank you for the input. I was using a junction table to pull in customer information, such as CustomerName, Region, etc. But I have since removed it and will replace it with another junction table because I think what you are saying is the following.
Create a junction table to pull in information from my Tasks Table and Subtasks table
On the junction table:
Pull in Task information, such as: TaskName, Status, owner, task due date
Pull in subtask information, such as SubTaskName, Status, owner, subtask due date
Then create the following fields on the junction table
Task promised date, who has next step,
Subtask promised date, who has next step
Is this what you are saying?
Also, one more question. If this is your suggestion, does this mean that the best way to operate progress of tasks and subtasks is to work from the Junction table (instead of editing the tasks table, and the subtasks table)?