track changes???

[parallon]

Hello all. I am wondering if there is a way to tell when I input data in the front end of an application, exactly which tables and fields are affected by that change? Is this anything that would be easy?

Thanks in advance,

Parallon

"I used to think that the more that you knew, the farther you would go, then I realized that the more that you know, the more they use you."

-Me

 

[scriverb]

If what you are asking for is a table editing log then yes, this is an complicated matter. It can be done where you create a log table with fields like Tablename, RecordID, Fieldname, DateOfEdit, TimeOfEdit, UserName, OldDate, NewData. Everytime a field is modified then a record is created in code. This provides for a complete data history of your tables. The level of detail that you need would dictate the complexity of this process.

I am sure there are threads here at TT or in the FAQ where a record history was discussed. I haven't looked yet but a search would be helpful at this time.

Post back if you have questions.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]