I am looking for a way to calculate the distance between 2 tables and show me a dropdown list of the stores that fall within a particular radius.
I have a table of stores and I have a table of sites. Both tables have GPS coordinates. I want to be able to allocate a store to a site depending on the distance from the site. The radius is 5km
Please can you advise on the expression I should use to give me the dropdown list.