adding new entries to table

I have three tables.

People - id is primary key
Training - training as primary key
People_Training - id and training as foreign key.

I created a main form (people table) with a subform
(People_Training table). For each person, all the
training that they've taken is listed. I can only select
the items that is already in the Training table. Is there
any way to add a new training to the training table
through the field from the subform and to have it updated
for that person?

Thanks.

If the Training field is Text (not AutoNumber), and it is represented by a
combo box in your subform, you can use the NotInList event procedure of the
combo to add the new Training text to the Training table on the fly.

Details and example in:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ashley" wrote in message
...
I have three tables.

People - id is primary key
Training - training as primary key
People_Training - id and training as foreign key.

I created a main form (people table) with a subform
(People_Training table). For each person, all the
training that they've taken is listed. I can only select
the items that is already in the Training table. Is there
any way to add a new training to the training table
through the field from the subform and to have it updated
for that person?

Thanks.