I want to be able to track employees and the jobs that they do at different levels in their career.
A job can be carried out by an employee at level1. That same job type can be carried out by the employee when they reach level2. How can I set this up.
I have
tblJobs
JobID (autonum, primary key)
JobTypeID (number, child key)
EmployeeID (number, child key)
Date (date)
JobNotes (memo)
When I create the queries/reports I want to list all the Jobs carried out by the employee for a set time, but want to also break it down by their level. They can only be at one level at any one time, and usually progress up the level ladder with time.
EG
Jan 1990 – Jan 2000
Employee John Smith
Job Type A
Level 1 = 100
Level 2 = 200
TOTAL = 300
If more than one employee worked on a Job, I would need to break it out into a junction table for the many-to-many relationship (a Job can contain many employees and an employee can be involved in many Jobs). How would I incorporate their level into this structure too?
Thanks.
A job can be carried out by an employee at level1. That same job type can be carried out by the employee when they reach level2. How can I set this up.
I have
tblJobs
JobID (autonum, primary key)
JobTypeID (number, child key)
EmployeeID (number, child key)
Date (date)
JobNotes (memo)
When I create the queries/reports I want to list all the Jobs carried out by the employee for a set time, but want to also break it down by their level. They can only be at one level at any one time, and usually progress up the level ladder with time.
EG
Jan 1990 – Jan 2000
Employee John Smith
Job Type A
Level 1 = 100
Level 2 = 200
TOTAL = 300
If more than one employee worked on a Job, I would need to break it out into a junction table for the many-to-many relationship (a Job can contain many employees and an employee can be involved in many Jobs). How would I incorporate their level into this structure too?
Thanks.