Display most recent date from sub-set of dated records
Hello again. I have a table of records we'll call Visits, another table called Suburbs and a third called Shops. Visits, the master list, contains records holding data of shops, suburbs, date(s) visited, and more. Every visit to every shop has its own record.
The shops table (& layout) lists every shop with a portal displaying data of each visit. Works fine.
The Suburbs Layout displays the list of suburbs containing (or known to have no) shops.
In the Suburbs layout, I need to display how many shops there are in each suburb, and another field displaying the date of the most recent visit that has been made to any shop in that suburb. Ideally I would have the latest visit date for each of the shops.
As usual assistance would be greatly appreciated. Thanks.