>Anyone have any good ideas on saving changes made to certain fields to a table every time the value of the field is changed?
>
>I want to use field level triggers in the fields I want to capture, within the tables in the DBC, to save every time the value of that field changes. I would like to save the change to another table that has same field structure as the field being changed. I don't want to save the change to a memo file, it's a pain if I need to research and I can't quickly add the value back to the original table.
>
>Is there a discussion on this subject somewhere out on the thread?
You mean track the history of changes to a certain field by inserting a record into an
audit table?
MyAuditTable structure
KeyID [I]
TableName C[30?]
FieldName C[15?]
EditDate [T]
FieldType C[1]
NewVal C[120]
Then use an update trigger. You will need to use the transform function to populate the NewVal field. IMHO, I really do not see a problem using a memo field for the NewVal field.
Mark McCasland
Midlothian, TX USA