What I have:
tblTRAINING_DATA
-TrainingID (PK)
-EmployeeNumber (FK)
-CourseID (FK)
-Date
What I am trying to do:
If I have a group of 50 people who attend a course, I want to be able to update the corresponding records in the table.
The problem:
Currently, I have a form with a datasheet subform in which I have to navigate to the appropriate employee, find the appropriate record in the subform (quite the daunting task with the amount of courses there are), and then update it. Then I have to go to the next person's record and repeat the process.
There must be a more efficient way. I have thought of an update query, but can't figure out how to select specific employees to apply the changes to.
Thank you in advance for your time and help. Have a nice day.