keeping track of changes

[thompm65]

Is there a way FM can keep a list of changes made to a record and when the changes were made? For instance, if I make a change to an address I would like to see a quick note (maybe in a table) saying Address change - date.

Thanks, MT

[Lee Smith]

This typic comes up from time to time. Take a look at this recent thread Link

Lee

[BruceJ]

This is referred to as an AUDIT TRAIL.

There are many versions of this and some are extrmely comprehensive and sort of frightening to the uninitiated.

The ones i usually use are for medical records which have to be very complex, but for what you are looking for you could easily put together a caclulation that returns this info.

Look for Audit Trail and sort through them for a simple one that just shows the field and when/who modified it. The complicated ones will show what the data was and what it changed to... probably more than you really needed.

Another simple way is to use a calc that shows timestamp of last time the record was modified - really easy.

[Lee Smith]

Hi Bruce,

Did you look at the link I posted?

Lee