I'm trying to get the final problem solved before I can get the project I've been working on launched.
The main issue with searching was resolved thanks to Barry in the thread further down the page, however I've been left with one last little niggle that I just can't find the answer to.
Each search result is that of an Organisation which may have a Venue, the Venues are controlled through a many_many relationship since quite a few Organisations share a venue. The problem I have is that I can't get the actual data of the Venue outputted on the search results page, I have tried the usual <% control Venues %> bit but that didn't work.
Does anyone know how to do this? I could just add in a new batch of fields for the venue details in the Organisation DataObject but I'd rather keep them separate since so many of the Organisations share venues it seems daft to make the client reenter the Venues so many times.
Thought I'd add a wee bit of code in that might help explain what I am trying to do.
This is in OrganisationHolder.ss, basically if a Venue is attached to the Organisation it gets the Latitude and Longitude of the Venue and outputs it, if not it gets it from the Organisation object itself: