Use drop down boxes to access data in self-contained database

[Guest]

I'm desperate! I have a deadline aproaching quite fast and I can't figure out
how to do this.

I have a page in FrontPage with 5 drop down boxes. Each one has a number of
choices. The idea is that the user will make the 5 selections and obtain
advice on how to proceed. I created a database in Access. I have my page with
the drop down boxes. HOW DO I LINK THEM?

I suppose some kind of "Submit" button should be added, but how does it know
to take the selections to the proper query and display the results?

Please help! I have to have a prototype delivered in 4 days!

Thanks!

 

[Kevin Spencer]

Well, Gaby, you've got a lot of work ahead of you. What you're describing
may or may not be achievable with the fairly simple database functionality
avaialbe through the FrontPage wizards. I can't tell for sure because you
haven't been very specific about how this is supposed to work. Chances are,
you may have to write your own ASP. Here's a good place to start learning:

http://msdn.microsoft.com/library/en-us/dnanchor/html/activeservpages.asp?frame=true

There is a possibility that this can be done with the Database Results
Wizard alone, that is, if you're creating a form that contains fields that
constitute the criteria for a SELECT SQL statement, and that the result page
should contain the result set from the criteria. If so, see:
http://office.microsoft.com/en-us/assistance/CH063547611033.aspx

--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Surgery

It takes a tough man to make a tender chicken salad.