I have this database that requires me to find suitable workers for certain jobs.
Each staff members has 5 different skills, with the skill level either Low, Average or High which are in a combo box. This is in a form which holds staff data. In another form are the skills and skills levels required for certain jobs also in a combo box each low, average or high.
What I need to do is find which employees have suitable skills levels to do that particular job. Considing if the job requires one of the skills to have an average rating, workers which have an average or high rating are suitable for the job.
I have included a sample of what the tables look like the the field names included.
(Name of table is "Jobs List"
Name Data Type Field Size
Job Title(Primary Key) Text 4
Word-Processing Text,Combo Box(Low, Average, High)
Typing Text,Combo Box(Low, Average, High)
Filing Text,Combo Box(Low, Average, High)
Shorthand Text,Combo Box(Low, Average, High)
Book-Keeping Text,Combo Box(Low, Average, High)
(Name of table is "Personnel"
Emp No(Primary Key) Text 4
Word-Processing Text,Combo Box(Low, Average, High)
Typing Text,Combo Box(Low, Average, High)
Filing Text,Combo Box(Low, Average, High)
Shorthand Text,Combo Box(Low, Average, High)
Book-Keeping Text,Combo Box(Low, Average, High)
What I need to do is find all the employees' that have a skill level that is equal or above to the corresponding fields in Jobs List.
Thanks for all of your help in this I really appreciate it. If you know how to solve this, or know of a better way to do this please let me know. Cheers!
Each staff members has 5 different skills, with the skill level either Low, Average or High which are in a combo box. This is in a form which holds staff data. In another form are the skills and skills levels required for certain jobs also in a combo box each low, average or high.
What I need to do is find which employees have suitable skills levels to do that particular job. Considing if the job requires one of the skills to have an average rating, workers which have an average or high rating are suitable for the job.
I have included a sample of what the tables look like the the field names included.
(Name of table is "Jobs List"
Name Data Type Field Size
Job Title(Primary Key) Text 4
Word-Processing Text,Combo Box(Low, Average, High)
Typing Text,Combo Box(Low, Average, High)
Filing Text,Combo Box(Low, Average, High)
Shorthand Text,Combo Box(Low, Average, High)
Book-Keeping Text,Combo Box(Low, Average, High)
(Name of table is "Personnel"
Emp No(Primary Key) Text 4
Word-Processing Text,Combo Box(Low, Average, High)
Typing Text,Combo Box(Low, Average, High)
Filing Text,Combo Box(Low, Average, High)
Shorthand Text,Combo Box(Low, Average, High)
Book-Keeping Text,Combo Box(Low, Average, High)
What I need to do is find all the employees' that have a skill level that is equal or above to the corresponding fields in Jobs List.
Thanks for all of your help in this I really appreciate it. If you know how to solve this, or know of a better way to do this please let me know. Cheers!
