Thank you.
It's now a bit more complicated. Our database consists of a main photo (keyart) along with other data including the country the photo was shot. We have set up a a list to show the keyart only and the list is displayed in a 4 x 10 grid. The grouping is to allow us to show a row of photos from Germany and France etc. So we want to show:
Germany
German photo, German photo, German photo, German photo
France
French photo, French photo, French photo, French photo
etc
I figured out the grouping, its the displaying the country label before the row and limiting the records to 4 per country that is a challenge. And if there were only 2 keyart for a country it would need to show those 2 keyart (versus 2 plus 2 from another country).
Thanks in advance!