Sort by Modification Date

[Randy]

Hello,

I have a list of clients that I would like to sort by the most recent modification date, so that the most active client records are at the top. I can create a field and auto-enter the modification date, but what types of action cause "modification". Once that field is populated, sorting by it should be relatively easy, yes?

Thanks in advance!!

[Vaughan]

Good question... I just tested it and found that the modification date is set only if a field value is changed. Just clicking in a field and exiting again does not change the modification date. However, deleting text and retyping it exactly the same does count as an edit.

Sorting will be very easy, yes.

[Thom]

Also note that modifying related fields does not affect the modification date in the master record.

[Randy]

A follow up to the modification issue -

My list of clients leads to detail layout of contact info, etc., as well as portals to all of their PO's, contracts, and communication. If I make a change to any one of these related databases, I'd like it to "update" the master modification date.

Thom's post makes it clear that this does not automatically happen. Can anyone think of a calculation that would update the modification date in the master record when a related record is changed or created? I'm thinking along the lines of an evaluation of the related modification dates that selects the most recent and sets the modification date of the master record. I can then sort by that date.

Thanks!!

[Anatoli]

You can make calculation in Master:

ModDateMaster = AutoModDateRelated.