I have a collection of 'Owners' and I have a collection of 'Listings'. So each listing is connected to an owner. Some owners may have many listings. In the owners collection, one of the fields is 'location'.
I have a category page that displays all listings in a repeater. I want users to be able to search the listings using a dropdown based on the owner of that listing's location.
So if the code for the filter is:
How do I make the propertyname = the location of the listing's owner?
I've searched the forums and I can't work out whether this is possible or not? Is the only option to add the owner's location as a field in the listing? This seems like it would be time consuming and very open to human error.