A
alwayslearning
My database has a main table called "Projects" with a unique number
"ProjectID" as primary key. Each project has an "Owner". When the owner
changes before the project is complete, I capture that in another table
called OwnerHistory. Each record of this table has, in addition to a
"ProjectID", an owner name and a date of change, etc. The second table is
necessary because of the one to many relationship. I have a data entry form
displaying the current owner from the main table, and also the historical
owners in a subform.
Problem: When the user changes the owner name on the main form using a
combo box control, I want to trigger an event to add a new record to the
OwnerHistory table so the user doesn;t have to enter the information twice.
I've tried going at this both ways - driving an event from the exit of the
control on the main form, and from doing a new entry in the subform. Results
less than pleasing. Help appreciated!
"ProjectID" as primary key. Each project has an "Owner". When the owner
changes before the project is complete, I capture that in another table
called OwnerHistory. Each record of this table has, in addition to a
"ProjectID", an owner name and a date of change, etc. The second table is
necessary because of the one to many relationship. I have a data entry form
displaying the current owner from the main table, and also the historical
owners in a subform.
Problem: When the user changes the owner name on the main form using a
combo box control, I want to trigger an event to add a new record to the
OwnerHistory table so the user doesn;t have to enter the information twice.
I've tried going at this both ways - driving an event from the exit of the
control on the main form, and from doing a new entry in the subform. Results
less than pleasing. Help appreciated!