Max of Record Id using Formula Query
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...
Forum Discussion
MarkShnier__You
Qrew Legend
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])