I have what appears to be a simple problem but for the life of me i cannot find a solution, DB has not been developed yet so i cannot post a sample
situation: have a group of employees, each month these employees need to complete some sort of training, some months only one others as many as 7. anyway, i have been tasked to develop a db to track this.
sounds simple but i cannot seem to figure out how to do it. i need to have a form where the employer can enter a new training item and have it relate to all the employees. so when he runs a query it shows which employee has not completed this training item.
so i am stumped with how do i assign a new training item to all 30+ employees and have it place some sort of checkbox to show completion
any ideas would be greatly appreciated
Ricky
situation: have a group of employees, each month these employees need to complete some sort of training, some months only one others as many as 7. anyway, i have been tasked to develop a db to track this.
sounds simple but i cannot seem to figure out how to do it. i need to have a form where the employer can enter a new training item and have it relate to all the employees. so when he runs a query it shows which employee has not completed this training item.
so i am stumped with how do i assign a new training item to all 30+ employees and have it place some sort of checkbox to show completion
any ideas would be greatly appreciated
Ricky