MS Access, adding a detail to multiple contatcs at once?

Soldato
Joined
31 May 2009
Posts
21,468
Building a training database
I have records for all staff, and task lists associated with it
Is it possible to generate a form that lets me assign a value (ie a name of a course and the date in which is was completed) to multiple people at once?

So I have my staff list and within their contact details I have a separate sheet for training, is it possible to design a form which would allow a drop down box, or multiple selection box, which would update lots of different contacts at once, with information on training provided, so one doesn't have to enter every course for every member of staff at one time.
 
I think I have managed to create a table capable of accepting the data I wish to add.

My issue now is getting the appropriate information to display within a new tab of a 'contact details' form request, when the contact form is opened.
 
Of my two main tables, contacts and training
Contacts record peoples general info
Training is more specific, and has fields for when, duration, trainer, and who attended.
The who attended field has been set to allow multiple values, so everyone who attended a session can be added.

What I am trying to do is general a query or report or subform that enables me to find all training sessions attended by a person. I can't find a way to query the 'who's attended' field. I can output the values from the who's attended field if I query any other field in that table, but I can't seem to query a field with multiple values looking for any name within it.

Anyone help me on process to achieve what I need?
Any attempt to add a second page which links the
 
Back
Top Bottom