Skip to main content
Solved

Getting link to related record based on a max date

  • February 4, 2026
  • 0 replies
  • 157 views
Forum|alt.badge.img+12

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?

 

Best answer by DonLarson

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.

 

Forum|alt.badge.img+15
  • DonLarson
  • Qrew Cadet
  • Answer
  • February 6, 2026

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.

 

Terms & ConditionsAccessibility statement