How to store zipcode/street/House No

Need help Database
1

Hi Guys

As soon as a user type in a zip code a list of available streets and street numbers within that area should appear.

I tried the google maps api to achieve that feature but unfortunately I can’t sort the google maps api by country/district.

Should I try it with option sets or is there a simpler solution?

2

An example

If a user type zip code 8330 he can select street A,B,H
If he select zip code 8330 and street H he can select streetnumber 13/14/19