Solved
Getting link to related record based on a max date
I have two tables. The main table is DSO and the related table is activity. I'm trying to get a report grouped by the DSO Name and bring me back the record ID of the activity where the field Date R...
Carol,
Since you said you wanted a report, you should not need the Max RID.
You are getting the Max Date from the Summary field.
Make that Date a Look Up value back in the Activity Table
Create a report where Activity Date = Max Date
Then embed that report back in the DSO table.
