I am trying to set up a searchable database that can allow me to add thousands of contacts. I plan to upload my existing spreadsheets of contacts and want to be able to search within 100 miles of any area I enter. Example. I am looking for someone within 100 miles (or a list of all contacts that meet that requirement) of any entered location.
You can look up the Contact's lat and long based on a relationship.
Then you need to calculate the distance between an entered location and the contacts.
There is a discussion here
and I have done exactly that setup you are looking for for another client. The whole setup beyond what is already posed is probably too complicated for me to explain on this Forum, but if this is something that you really need done, then yes it can be done, and you can contact me off line.
It can be easily adapted to use an entered zip code. Feel free to contact me off-world if you need assistance with implementing this feature.