P
Paul
I have a form with all the fields shown based on a table. I need to track
all the changes to the fields like "edit", "delete" or "new". I create a new
table called Tbl_History which is a one to many relationship to that table
with the following fields, HistoryID(PK), PK of the Table 1(FK), FieldName,
PreviousValue, NewValue, Date. Therefore when user make a change to the
record of that field, it will track the old value as well as the new value
to the History table and someone can verify the change and if needed the
record can be rolled back to the old value. I am not sure what "event" or
"events" I should apply to the fields I need to track the change in the
form. Also how to append the "field name" to the History table. Any
suggestion or sample would be appreciate. Thnaks.
all the changes to the fields like "edit", "delete" or "new". I create a new
table called Tbl_History which is a one to many relationship to that table
with the following fields, HistoryID(PK), PK of the Table 1(FK), FieldName,
PreviousValue, NewValue, Date. Therefore when user make a change to the
record of that field, it will track the old value as well as the new value
to the History table and someone can verify the change and if needed the
record can be rolled back to the old value. I am not sure what "event" or
"events" I should apply to the fields I need to track the change in the
form. Also how to append the "field name" to the History table. Any
suggestion or sample would be appreciate. Thnaks.