So the training database that I implemented was a huge hit to all the other departments and now they want to have one of their own. However, instead of having 7 different databases, I proposed having just one, figuring that I could divide out the employees based on their department numbers. Below is the orginal post that I had that JZ responded to so quickly:
Here's what I have:
I have 1 table with all of my employees
I have 1 table with all of the tasks listed in my shop
I have 1 table with training level, which shows the level of conmpetence an employee would have at each job.
My goal is to attache all tasks to an employee and show the training level for each job the person has been trained on.
For instance:
Bob Employee
Tasks Training Level
Installing Windows 1
Installing Door Seals 3
Installing Outside Mirrors 2
Installing Overhead Harness 4
So I would be able to build a query using employees clock number at it would show what task the person has been trained on and what level of competence that person has.
How can I relate each of these tables to show multiple tasks to one employee?
So in an attempt to try and come up with something on my own, I have pretty much screwed up a working copy (the one in current use is safe and secure, backed up once a week)
So here is what I have now:
1 table for all departments
1 table for employee tasks
1 table for training levels
1 table for all task
Their are two addtional tables that JZ created that contains information but I do not know how it got there.
Here is my ultimate goal - This database needs to show:
1. Department where works
2. What tasks they have been trained on
3. What evaluation level they have achieved
4. Enter in a task number to show which employee can do the task and what competence level they are at, regardless of what department they are currently in.
Once I can get help on how to relate all this information, building queries, creating reports and forms is something that I can do...and once it is shown to me, I can pretty much understand what was done. However, I am in the state that I can't get there from here.
Any help would be greatly apprciated...
Thanks in advance!