Calculation to get most recent status for a log of records
I am trying to create a calculated field that gives me the most recent status for a record.
I have a log of records that each have an ID, the ID can be duplicated in the database many times with different statuses which have a timestamp to them.
I want to be able to create a calculated field that indicates that that perticular record is the most recently created status for a given ID.
How would I go about doing this? The field would need to be such that it would constantly update as new records are logged.