I have a directory list of places with addresses. When a user looks at the details of one of these places I want to add an in-line list below that shows other places that are nearby.
I am using the distance column elsewhere but I can’t work out a way to calculate the distance between the currently selected place and all other places in the directory that I can then filter based upon distance away.
I have tried adding in a column that copies a ‘1’ to all rows in the directory and then creating a multiple relation to this which returns all of the places, but if you then try and create a distance column using this relation it returns one value (I.e. it doesn’t recognise multiple entries).
Does anyone know of a way around this?