Hi - I have a table set up like this:
Contractors (details of people)
Jobs (individual jobs)
Each contractor will have new jobs assigned to them. I would like to know if a job has been assigned more than 5 days ago. What is the best way to do that?
The idea here is that each job has notes on it and if i can see when the job was assigned then I can see if there has been no action taken on it yet and send a reminder. The complexity is that each job could have more than one contractor assigned so I need to know specifically that contractor B has taken no action even though contractors A and C have been making notes.