![Cathy_Pennicott Cathy_Pennicott](https://community.airtable.com/legacyfs/online/avatars/2X/8/8eeb8139b71e4d0dc164fcc510c433840a676dfa.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2020 03:09 AM
I have a table of Customers and a table of memos which are related to the Customer by Account number and in the memos table I put a note each time I speak to the customer with basic info of the date the person I spoke to and what was said.
In the Customer table I would like to see the Max (Memos:Date) ie the latest date that I spoke to the customer. At the moment it shows me all the dates as I have used it as a lookup since I cannot find a way to get the Max from a related field as a date. Anybody have any ideas please. I usually use Filemaker and the relationships then are quite transparent so am struggling a bit
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 25, 2020 06:25 AM
You want a rollup field (versus a formula field). Have the rollup use the aggregation formula MAX(values)
on the {Date} field in the [Memos] table. On my computer, the place to select the field to rollup is hidden–I have to scroll to find it.
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)