jordanking
Programmer
- Sep 8, 2005
- 351
(Access 2007 APD with SQL 2005 WORKGROUP back end)
I am looking for a better way to compare records from two recordsets (customer order details).
I have two tables, one stores "master" data, and the other is a "working table" which has mostly the same structure as the first. When users enter new data, it goes into the working table. When the user is done (closes the form or saves), the working info is checked for data integrity and moved to the larger "master" table and removed from the working table.
When the order record with details is "re opened" at a later date I repopulate the working table with the records and allow the user to make changes. I am looking for a way to compare the two recordsets for changes in order to insert an audit log into another table. I know that I can just loop through each recordset and check each field on at a time, but i was wondering if anyone else has come across a similar situation and knows of a faster way to do this?
.....
I'd rather be surfing
I am looking for a better way to compare records from two recordsets (customer order details).
I have two tables, one stores "master" data, and the other is a "working table" which has mostly the same structure as the first. When users enter new data, it goes into the working table. When the user is done (closes the form or saves), the working info is checked for data integrity and moved to the larger "master" table and removed from the working table.
When the order record with details is "re opened" at a later date I repopulate the working table with the records and allow the user to make changes. I am looking for a way to compare the two recordsets for changes in order to insert an audit log into another table. I know that I can just loop through each recordset and check each field on at a time, but i was wondering if anyone else has come across a similar situation and knows of a faster way to do this?
.....
I'd rather be surfing
