Update query?

  • Thread starter Thread starter livin''''life
  • Start date Start date
L

livin''''life

Hello all and thank you in advance for any help you can give me.
I have tbl_employee, tbl_training and tbl_trainingcomplete set up as follows:

1. tbl_employee
employeeID (PK)
lastname
firstname
MI

2. tbl_training
trainingID (PK)
classname

3. tbl_trainingcomplete
employeeID
trainingID
datecompleted
dateentered
userentered

I have a form with a combo box to select the training, a text box for the
date completed and a list box to select multiple employees. I would like to
add all the selected employess to tbl_trainingcomplete with the selected
class with the entered date. I am just having difficulty on what approach to
take. I was thinking that using an update query to do this would be the best
approach but I would like to get input from the experts on the best way to go
about this.

Was I correct in the way I set up the tables? I have been reading up on
keeping the database normalized want to make sure I am on the right track.

What would be the best way to go about adding the records to
tbl_trainingcomplete? Any help would be appreciated. Once again, thank you
for your input and help.
 
Search on these post for information of setting up training database for
re-occuring training, The one on maintence also has re-occuring events.

SUBJECT AREA
POSTER
Tracking Training Dates – Queries - 5/16/2006 2:40 PM PST Badboytim

Tracking annual training when my fiscal year – Queries - 7/22/2005 2:14 PM
PST CevinMoses

vehicle maintenance – tabledesign - 4/6/2007 7:20 AM PST Shanin

Form for attending Training – forms - 5/22/2006 11:45 AM PST CiceroCF
 
Back
Top