1-step history of field

[TeofenGL]

I need to put something together that would keep the previous state of a field in another field, as well as a change date.

For ex, let's say we have the field price, i would want a field named, say oldPrice, which would hold the value of the field before it was last changed and a priceChangeDate field which would hold the date and time of change.

initial experiments with calculations haven't gotten me anywhere just yet...

anybody have any pointers?

tia

[-Queue-]

Do a search on this site for +audit +trail.

[Lee Smith]

If I'm understanding your correctly, you are describing creating an Audit Trial, often referred as Field Modification Tracking.

A search of the Forum for Audit revealed these threads

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=91448

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=51903

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=41559

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=46383

And you might want to take a look at these sample files also:

Field Modification By: John Mark Osborne URL:

http://www.fmfiles.com/tnt4.html

Field Modification Tracker By: Bob Cusick URL:

http://www.fmfiles.com/tnt2.html

Modification Log By: John Mark Osborne URL:

http://www.databasepros.com

Tracking Modifications By: Steve Wilmes URL:

http://www.fmfiles.com/tnt2.html

HTH

Lee

[toolUser]

Thanks, will check them out.

Jerry