I have a database that keeps track of employee training completion and due dates and im trying to figure out how to append a new training record to everyone’s record in the database. what I have now is if a new user is created a template is put into their record with all of the required training. The problem that im having is that the type of training everyone needs sometimes changes and i want to be able to add it to people that are already in the system
I have everyone’s information listed in the PersonnelMain table I want to pull the SSN from there then use the data from Me.Combo14 for the training type then use Date for DateCompleted and DateDue. I just cant figure out a route on how to do this any guidance would be awesome
PersonnelMain.SSN = *, Type = Me.Combo14, DateCompleted = Date, DateDue = Date
I have everyone’s information listed in the PersonnelMain table I want to pull the SSN from there then use the data from Me.Combo14 for the training type then use Date for DateCompleted and DateDue. I just cant figure out a route on how to do this any guidance would be awesome
PersonnelMain.SSN = *, Type = Me.Combo14, DateCompleted = Date, DateDue = Date