Transaction logging

[leahpo]

Hi,

I need to monitor all transactions in the database.

I already have field that records Modifier Name, and Modified Date/Time.

But these apply to whole record. I have a file with > 400 fields, and I wanted to create a log of:

Field Name & Modified Date & Modifier Name.

I created Transaction log field, text, and set field option = calculation =

Status(FieldName) & Status(CurrentDate) & Status(UserName).

I tested it, and this field is not updated.

I can create a script that will do this and attach it to each field, but there are too many fields.

Any better ideas?

Thanks

[Kurt Knippel]

I think that Bob Cusick over at www.clickware.com has some examples of how to do this. Or check with John Mark Osbourne at www.databasepros.com for this.