modification reports.....

[anita hamis]

Hi guys,

I have been working on a script that reports any changes made to records.

I.e the number of modifications done to a record by a user.

I have been quite successful in achieving this, problem is the most recent change replaces the one that was there before, making it hard to track the original values.

I would like to make it possible to store all modification values.

say.

Modification(a) name-"john"

( name-"jahn"

© name-"jhn"

Any ideas?

anita

[Korky]

I presume you are storing the user name in a text field and that this was achieved using 'set field'.

If so make the calculation read something like;

Set Field,User History,User History&^&Current UserID

[^=Carriage return]

All this does is add a carriage return and the name of the new user to the existing data.

[The Bridge]

If you want to track all changes made to a database, you may want to try creating a separate "log" database to do this for you. This would require some creative scripting.

The basic idea is that each of the scripts in your current database that create, delete or modify a record will call a script in the log database which will create a new record and fill in the unique record id from the original record, the details of what was modified, by whom, when, etc.

Hope this gives you some ideas!