adding new entries to table

  • Thread starter Thread starter ashley
  • Start date Start date
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.
 
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
 
Back
Top