I have a table that tracks employees, their shift, the jobs they are able to do and various other items pertaining to their position. I want to add a combo box that the supervisor will select a particular job that the employee is doing that night. It could also be a radio button - I am open to different ideas on what would work best. When the job is selected I would like it to create a new record (either in the same table or to a new table) with all of the employees information, the job worked and then date stamp it so the supervisor doesn't have to type a date in as to when they last worked that job. Each night the supvervisor will go into each employee to enter their hours and overtime hours and then select what job was worked.
It will need to keep creating a new record each night so that is why I was thinking of having it go to a different table and just pulling in the Employee, Shift, Job Worked and then the date so there isn't so much duplicate data.
A report then would be run to show that Employee A worked Job 1 on these dates.
How do I get it to either add a new record to table 1 each night that a job is selected and date stamp it or copy the employee, shift and job worked to a new table and date stamp it.
Appreciate any help that can be given
Angie
It will need to keep creating a new record each night so that is why I was thinking of having it go to a different table and just pulling in the Employee, Shift, Job Worked and then the date so there isn't so much duplicate data.
A report then would be run to show that Employee A worked Job 1 on these dates.
How do I get it to either add a new record to table 1 each night that a job is selected and date stamp it or copy the employee, shift and job worked to a new table and date stamp it.
Appreciate any help that can be given
Angie
