When a field value changes on a record copy record to new table

[JWILLEY]

I have an asset tracking database to record what asset is assigned to what person. Now I am interested in making a 'real-time' history for each asset.

When any field changes on a record the record is copied to a table to inlcude date of record change.

Any clue how to do this?

 

[SydneyGeek]

Here's one way of tracking changes to a field.

Denis