B
BillGrubbs
I have a database that uses forms to update records in a table. I would like
to preserve historical data, so that the updated record shows up in the form,
but the former (historical) record is still in a table. I believe that an
append query is the best way to do this, but I have had endless problems
getting it to append ONLY the updated records. Each time I update a record,
it tries to append all 216 records, even though only one record has changed.
I have tried assigning the query to an afterupdate event procedure, but it
still tries to append all 216 records, instead of just the updated record. I
have also tried putting both the sourse and recieving tables into the query
and assigning a relationship that specifies all records from the source table
and only those records from the recieving where the records are equal. I
have also tried the reverse of the aforementioned statement. I am using the
following Tables:
Source Table: Nurse
Fields:
Nurse ID(primary key)
LEA
Term
Type
Name
Education
Hire Date
Certification
Salary
License Recieved
License Expiration Date
Date License Recieved
Nurse Hiring History Table(where I want the records appended)
Will have the exact same fields as listed above.
I do not want to have to view a counties entire hiring history in order to
view the current data in the form which updates the source table, but I need
a way of preserving the former employees information automatically when the
form is updated. Again, I do not want to view the old data on a daily basis,
I just need it to be saved in a table for later query, without requiring much
effort on the part of data entry personnel.
to preserve historical data, so that the updated record shows up in the form,
but the former (historical) record is still in a table. I believe that an
append query is the best way to do this, but I have had endless problems
getting it to append ONLY the updated records. Each time I update a record,
it tries to append all 216 records, even though only one record has changed.
I have tried assigning the query to an afterupdate event procedure, but it
still tries to append all 216 records, instead of just the updated record. I
have also tried putting both the sourse and recieving tables into the query
and assigning a relationship that specifies all records from the source table
and only those records from the recieving where the records are equal. I
have also tried the reverse of the aforementioned statement. I am using the
following Tables:
Source Table: Nurse
Fields:
Nurse ID(primary key)
LEA
Term
Type
Name
Education
Hire Date
Certification
Salary
License Recieved
License Expiration Date
Date License Recieved
Nurse Hiring History Table(where I want the records appended)
Will have the exact same fields as listed above.
I do not want to have to view a counties entire hiring history in order to
view the current data in the form which updates the source table, but I need
a way of preserving the former employees information automatically when the
form is updated. Again, I do not want to view the old data on a daily basis,
I just need it to be saved in a table for later query, without requiring much
effort on the part of data entry personnel.