Query using drop down lists?

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a database designed as a Business Directory for a
county. They want to have tourists be able to query this
data when looking for say "restaurants" in "Inverness"
etc. How do I design a form (?) to have drop down lists
that perform a query on the table of data? I want them
to be able to select the business type and/or location
they want and then get a list/report. This database is
eventually going on a webpage for the visitors to access.

Can Access 2000 do this, or do I need some other type of
front end program?

Thanks for the help.
 
Dear Mary:

Access is generally as good a tool as any for what you want in an
application. It may not be what you want for a website.

The selections you suggest the user may make are Business Type and
Location. These sound like they would be independent methods of
filtering the data. So, I take it the user may make a selection in
either or both of these categories independently.

Will the user select just one Business Type, or might they select
several? Will the user always select just one Location, or will you
allow them to select several?

How are you expecting to build a webpage out of this? For a public
website, Access is probably not a good choice. Only user who have
Access installed are going to be able to see Data Access Pages. So,
if that's your primary target, you may want ASP.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top