Hello,
My append query is adding too many rows. I have an add staff to training form, which uses combo boxes to do so.
The entries are added to the attendance table. I want to append these rows to the staff training history table (macro), which in turn will update each staff record.
What I have works in a way, but it appends all entries from the attendance table each time the macro is run, that is, there are many duplicates.
What can I do to make sure that only the current training's attendees' records are updated?
Any help is much appreciated. Thanks!
My append query is adding too many rows. I have an add staff to training form, which uses combo boxes to do so.
The entries are added to the attendance table. I want to append these rows to the staff training history table (macro), which in turn will update each staff record.
What I have works in a way, but it appends all entries from the attendance table each time the macro is run, that is, there are many duplicates.
What can I do to make sure that only the current training's attendees' records are updated?
Any help is much appreciated. Thanks!