Hi. I need a hand in setting up a relationship between zip codes and street names. We currently have the city field and state field data auto enter based on the zip. I'd like to be able to
A) enter a zip code, then select a relevant street name from an editable dropdown list
or
: Enter zip, then start typing the street name and have autocomplete show me the relevant street names.
I've attached an image showing how I have the data set up... My bet is that I need a new table for street names but I'm a noob at this so any help is appreciated.
This next idea is strictly a 'wish list' item...but any direction would be great. I'd like like to get a range of valid street numbers for a given street within a certain zip. The idea would be:
Enter zip: city and state auto-populate
Start typing street name: get possible matches
Click a dropdown and pick house number based on zip/street. Similar behavior to entering an address on a GPS device.
Thanks in advance!