Sorry for the vague title.
I have a problem which I will post in the forms section but it also relates to table set up and queries (i think).
I have added some screen shots to explain what I mean.
I have a small database that hold employee info.
I have an employee that works on a department, on that department there are certain jobs that need to be done and once employee has been trained can do.
There are several people working on the same department. The more people we have on one department that are trained and capable to do all jobs, the more flexible a department is.
I have following tables:
tblEmployee
tblDepartment
tblDepartmentJobs
I have created a form with 2 tabs: 1 - employee info, 2 - tasks/capacities
What I would like is that when I open the 2nd tab it shows me the screen like attached and where I can fill in the "score" per tasks. Ideally this means that for someone in the department Shipping the tasks from Shipping would appear and for someone that has been assigned Admin the tasks from Admin appear
Later on I would like to have a report which is sorted by department and that shows the tasks horizontally, the employees vertically and the score for each of the tasks.
I have a problem which I will post in the forms section but it also relates to table set up and queries (i think).
I have added some screen shots to explain what I mean.
I have a small database that hold employee info.
I have an employee that works on a department, on that department there are certain jobs that need to be done and once employee has been trained can do.
There are several people working on the same department. The more people we have on one department that are trained and capable to do all jobs, the more flexible a department is.
I have following tables:
tblEmployee
tblDepartment
tblDepartmentJobs
I have created a form with 2 tabs: 1 - employee info, 2 - tasks/capacities
What I would like is that when I open the 2nd tab it shows me the screen like attached and where I can fill in the "score" per tasks. Ideally this means that for someone in the department Shipping the tasks from Shipping would appear and for someone that has been assigned Admin the tasks from Admin appear
Later on I would like to have a report which is sorted by department and that shows the tasks horizontally, the employees vertically and the score for each of the tasks.
