I have a page for my [Locations] which has a Repeating Group of local [Shops], sorted by nearest to furthest away based on geographic address. Simple enough so far.
However my [Location] also has a field [List of Shops] which is used to specify the recommended shops for that location.
I’m happy enough searching for both of the above sets of data in my repeating group. However, I’d also like to be able to sort the resulting list so that the recommended shops (i.e. those in the List of Shops for that location) come top of the list.
I can’t think how to do this as a sort field…any ideas please?