How to keep a history of field inputs

[FLOWERS]

The challenge...

Customer has a field for "Current Status" of the record. Customer wants to see a history of who and when the "Current Status" was changed.

Field is populated with a value list selection.

Any short solutions?

[andygaunt]

1 solution.

Create a seperate database for current status history.

Fields required would be.

Creation Date (auto enter)

Creation Time (auto enter)

Creation User (auto enter)

Previous Status

New Status

Script the current status field to create a new record in the new database and set the field previous status to its current value. Then enter the new status and set the value across to its current status.