I would like to have a page on our website or a link to a web page that allows our customers to type in their zip code to find the closest retailer location that sells our products. The form should first ask what type of product they are looking for (3 choices) then would ask for their zip code. The results should come up as a list in order of closest to farthest, and they should then also have the option of looking on a google map to see the different retailers' pin locations.
The database needs to be an accessible spreadsheet that we can constantly add to or take away various locations. The database should contain the following information:
1. Name of retailer
2. Street Address
5. Zip Code
6. Phone number
Since we have 3 different types of products (beer, wine and spirits) we would need 3 separate databases.