I have a Parent Phonenumber table and a child Callhistory table. I would like to get the latest comment for the phone number from Callhistory table. Is it possible to get the max of record id for the phonenumber key using formula.
Qrew LegendI suggest making a summary field on the left side of the relationship to summarize the Maximum of the [Record ID#] field. The look that up down to the Call History table.
The make a new Combined text summary field of the [Comments] field in subject to the filter that the [Record ID#]. Now you have the most recent comment up on the parent phone number table, but it is going to have a strange bubble appearance. If you want that to appear more normally then create a new formula field like this.
ToText([Combined text comments])
