I’m attempting to set up a database to record employee training. I’ve set up the autolookup query (pic attached) to help form a set of default training courses/procedures that are mandatory for each department – if Department A requires eg CPR, Fire Safety and Working at Height training, the relevant DefaultTrainingID’s can be selected and all details are auto filled from tblTrainingCourses. Furthermore, if a procedure is revised, the revision for that training only has to be changed once in the tblTrainingCourses table.
I want to move to the next stage whereby these default courses can be pulled in to an individual’s training record when they join eg Department A but retain the ability to edit these records so that eg John Doe’s Fire Safety training record will reflect completion dates, current revision that he has been trained against etc. There will also be occasions when individuals require training for responsibilities additional to their departmental mandatory requirements - so Environmental Awareness may have to be added to the other 3 courses for Department A for John Doe
Could anyone please point me in the right direction at this point - will an update or append query, triggered by an AfterUpdate event on a form after selecting the employee’s department, be the best/most simplistic way of achieving this? Would appreciate a little steer
I want to move to the next stage whereby these default courses can be pulled in to an individual’s training record when they join eg Department A but retain the ability to edit these records so that eg John Doe’s Fire Safety training record will reflect completion dates, current revision that he has been trained against etc. There will also be occasions when individuals require training for responsibilities additional to their departmental mandatory requirements - so Environmental Awareness may have to be added to the other 3 courses for Department A for John Doe
Could anyone please point me in the right direction at this point - will an update or append query, triggered by an AfterUpdate event on a form after selecting the employee’s department, be the best/most simplistic way of achieving this? Would appreciate a little steer