Most Recent Record Relationship

[Gerald Clare]

Two files- Clients and Notes. A Client can have many Notes. I want the clients name in Client>ListView to be red when his most recent note is more than 30 days old.

I've gotten a portal list of dates to turn color appropriately but can't figure out how the field in Clients can 'know' which record in Notes to cue the conditional formatting.

I have a field in Notes that returns a '1' if stale and a '0' if not.

[email protected]

[comment]

The condition you want can be expressed as:

Max ( Notes::Date ) + 30 < Get (CurrentDate)

This is from the point-of-view of Clients, so you can either use this in a unstored calculation field to conditionally format the client's name, or - if you have version 9 - directly in the conditional formatting formula.