If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appending ONLY new records to a table
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Appending To A Table with Unique Records | Stoshu | Running & Setting Up Queries | 1 | February 1st, 2005 06:59 PM |
Manual line break spaces on TOC or Table of tables | Eric | Page Layout | 9 | October 29th, 2004 04:42 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Select records | Ricoy_Chicago | General Discussion | 6 | July 16th, 2004 07:12 PM |