Search results

The timetracker that I am building stores the history of the task in multiple rows. Here's a simplified view. Task ID | Assignor ID | Assignee ID | Description | Status 1 | 5 | 10 | I could not make this change. Please try at your end | assigned 1 | 10 | 2 | I made this change. Please check it...

I am building a simple task tracker to keep a record of tasks being passed back and forth between our team. The schema is fairly simple as illustrated in the image below. I want a recordset as follows out of this database (+/- few columns. But these are the most essential ones needed) -...