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.
If you have a solution for this problem of have any tips for me to get around this please tell me. This is for an important assignment for my course at university. Thanx
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.
If you have a solution for this problem of have any tips for me to get around this please tell me. This is for an important assignment for my course at university. Thanx