Designer156
Registered User.
- Local time
- Yesterday, 20:28
- Joined
- Aug 31, 2007
- Messages
- 12
I'm building a Dbase to log some jobs that come into my team, jobs will be allocated to an individual and come from a set of pre-determined customer's. A job can consist of one or multiple tasks from a list of around 20. Once complete I will be seeking feedback scores on the job and the individual tasks carried out.
The aim is to enable me to run reports that give me feedback scores for individual team members, frequency of use of our services by certain customers, feedback scores on jobs, but also by individual tasks.
Should I seperate everything out, so create tables for:
Team Mebers
Customers
Jobs
Tasks
Feedback
Or would it be best to combine the tasks and feedback in with the jobs table?
When I create new job, I want to be able to tick the various tasks required, and I can't see how to do this without combining the 20+ tasks in with the job table.
Any thoughts or guidance much appreciated!
The aim is to enable me to run reports that give me feedback scores for individual team members, frequency of use of our services by certain customers, feedback scores on jobs, but also by individual tasks.
Should I seperate everything out, so create tables for:
Team Mebers
Customers
Jobs
Tasks
Feedback
Or would it be best to combine the tasks and feedback in with the jobs table?
When I create new job, I want to be able to tick the various tasks required, and I can't see how to do this without combining the 20+ tasks in with the job table.
Any thoughts or guidance much appreciated!