I have a summary field on a parent table the reflects the Maximum Record ID of the child records.
I'd PREFER for this field to reflect the record on the child table with the last date value for an manually entered field.
My Machines parent table has a Status table and a summary field which reflect the latest Status Update. We manually enter the date because we cannot always add status updates on the same day and often go back, review the status history and try to fill in the blanks. The problem occurs when we go back and fill in some missing status updates that occurred prior to another sibling for that machine -- then the older update is shown in the summary field because it has a higher Record ID.