adding new entries to table

A

ashley

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.
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top