"Better" would depend on what you are trying to accomplish. It would be easy
in Access to match city and state, provided they are stored in the table of
stores whose location you want to return to the user. You'd need to write
some non-trivial code to try to do "closest zipcode matching", or use some
third party software.
And, perhaps you might clarify what you mean by "Another question is what
elements come first, second, third and what user information is needed in
order to obtain results?"
It is not clear that this is a question about Microsoft Access database
software -- that is the subject of this newsgroup.
Larry Linson
Microsoft Access MVP
"stiv" <st****@iwon-dot-com.no-spam.invalid> wrote in message
news:ze********************@giganews.com...
I'm in the process of designing a store locator database that is
searchable for the retail stores in a city and state. Which would be
better to impliment the city/state query or is it zipcode based?
Another question is what elements come first, second, third and what
user information is needed in order to obtain results? I have an idea
but would like more input. I'm looking for someone that has maybe
designed one so maybe I can get an idea or see a sample of what
tables are used to make this fully functional.
Thank you for your time,
Greg