HELP with a log file

[Pedro]

Hello,

I have a big database with about 70 fields, and i want to know how can i make a log file containing the user that have modified each field, when it was modified and the last value......

I have tried to do it and the modifier name and when it was modifed is very easy to do but I don't know how to store the last value???

It must to be done automatically....i can't wait the user to click in a button to perform a script...

Thanks and I waiting for replies.

[LiveOak]

You REALLY don't want to know the answer to this one! There is no way I know of to do this automatically. It will be a lot of work. What you need to do is:

1) Create and edit screen with a global field corresponding to each real field. That's right (70 globals).

2) To edit a record, the user find the record (all fields protected) and hits an "Edit" button. The script copies all 70 real field to the 70 global fields and navigates to a screen shown the global fields.

3) The user edits the data in the global fields and has two button choices "Enter" and "Cancel".

4) If the user hits "Cancel", the globals are cleared and the user returned to the normal field view.

5) If the user hits "Enter", the script compares each of the 70 global field to 70 real fields looking for changes.

6) When a change is found, the script make a new entry in the log file with the Time, Date, Field Name, Old Field Value, and New Field Value.

7) The script repeats 6) for each changed field found.

Ah, the price of being Big Brother!

-bd

[Pedro]

Thanks a lot Big Brother, i think it will solve this problem.

Thanks