 How to track the history of a selected number of fields in a record? Access2003 -
12-17-2004
, 11:16 PM
I have set up two tables ****current and ****history.
The history table contains all the fields which I want to track changes
on. The current table contains just the most recent information from
those fields (history not important).
The entry forms are set up with a query to access each field from it's
correct table. I have a 2 field primary key in the history table
(field 1 is a facility ID, and field 2 is the date of inspection). In
tracking the history the facilty ID will be duplicated, and the date
will also be duplicated for different records, but not both at the same
time (so I believed this to be the best way to go).
The problem I'm having is when I open the form it brings in the most
recent information from both tables, but when I go to save the record
(the facility ID is the same, but the date is different)it just
overwrites everything in the history table and doesn't create a new
record under the different date there.
Any suggestions would be appreciated. Thanks.
|
Linear Mode
