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 Roster Reconciled is the greatest.
I built a report and have the information like I want it but the link does not take me to the record of the activity.
I created a summary field on the DSO table relationship to the activity table that gives me the max of the date field and the max of the record id. I also added the lookup on the activities table. It's just the link takes me to the DSSO record and not the Activity record.
What am I doing wrong?
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.
