Renoir,

I haven't implemented this, but I would begin with the following VFP functions:

CurVal()
OldVal()
GetFldState()
AFields()

Let your imagination go from there.

Good luck.

>Not a charity case, but this client is through an agency and my time is the only thing that gets billed. I will get FoxAudit for my own contract work - it looks like it does a great job - but not for this one. In the meantime, do you have any ideas how I begin tracking record transactions at the database level? Doesn't need a lot of bells and whistles, just enough to be able to review what changes were done. Thanks!
>
>You're selling yourself short; I know your work and you're worth much more than $.02 for the last reply... Mmmm...unless you meant me! ;-)
>
>
>>Renoir,
>>
>>$259 vs. how much of your time? If the client is not a charity case, surely you can bill it out at your hourly rate. To plagiarize a bit, a waste of a perfectly good programmer's time.
>>
>>$.02 (Only $258.98 to go :o)
>>
>>>>>I've taken over a Visual 5 app that was converted from an old DOS 2.6 program. I need to be able to keep a table of any changes made during record edit. The previous developers held onto some of the logic that checked each field against its previous value to determine if a change had been made; I would like to handle this some other way. I'm considering doing something at the table level, but am unsure exactly where to begin. I searched through past threads and using triggers seems to be one option. Any ideas? Thanks!
>>>>>
>>>>>Regards, Renoir
>>>>
>>>>Check out FoxAudit class at http://www.takenote.com/foxaudit.htm
>>>
>>>That sounds awesome, but the client I'm doing this for is part of state government and $259 might as well be a million. I may get that for my own work, but for this application I would have to donate it to them, and enough of my income goes there way already... Anyone have other less slick-and-costly solutions? Renoir