Hi. I have been chasing a problem with a database change, that
I cannot find the source of... looks like a field is being updated incorrectly. (it only happens once every 1500 updates) I've put audit trails in to the app where I think its going wrong, but still cant get to the bottom of it.
The App has about 150 forms adn this partciular table could be updated from quite a number of the forms.

Is there a way of tracking table changes , preferably at the Database level, so I dont have to go into each form. My updates can be from Append, Replace with , Inserts and Updates .

If there was a trigger , where I could update a Log file with:
Date, Time, Field Value and most importantly Calling Form or Prg

Anybody know if this can be done ?
Regards,
Gerard