Training Database Query Help

[cjb1317]

Hello,

I am currently updating a training database for work and I am having problems figuring out how to deal with a new associate or an associate that is changing roles. I have a required list of trainings for each job and currently when you have a new associate you have to manually enter all the required trainings that they have to complete into their associate information.

I tried an append query but couldn't figure out how to just append each training for one associate and not my whole list of associates. I hope this is enough information I am fairly new to access and vba.

Thanks!

[orange]

What instructions do you have for your Training database?

Is there any info on
adding an associate
adding a training topic
etc?

[cjb1317]

There are forms that were already created that have text boxes that have a control source of the respective table for new associate or new training event. For a new associate you enter their first name, last name, ID#, and job classification. For a new training event you enter the event name, the trainers name, the classification, and the training cycle day.

[cjb1317]

^When you open the form for new associate entry to new training event entry it goes to a new record in the texts boxes so you don't overwrite information in the table.

[orange]

Are you working with forms, or are you trying to work directly with tables?
Was there any sort of User manual for the system?
Did anyone give you training on the system before you started "working with append queries"?

[cjb1317]

I didn't have any formal access training, I have an access manual though. There was no manual that was created for use on the database.

The database is used mostly for the trainers to enter in the associates that were trained for each event. There is a form for this where they choose the training and each associate. The associate information and training event information is all stored in a table

[orange]

Have you discussed the situation with one of the trainers that normally uses the database?