I am currently in the process of building a search facility on a website which will utilise dependent drop down menus...i.e there are five menus and each child menu is dependent on what the user has slected in the previous parent menu.
Is it possible to take the poduct which is in the final menu and query my MS Access database to return details of the product on the website? If so how?
Thanks for the post bit I fear I didnt fully explain myself, sorry.
What I would like to know is .... Can I take the information from the final menu and use it with ASP to search my Access Database?
i.e. I worked through the five menus, narrowing the search for a product down until i had one final product. I then use this information to search on the database, returning the details stored there to the screen usng ASP.
it connects to the db and runs the sql query and then counts the records so that you can loop through the results you could put in there a if then statement that would show something like
if RS15.EOF then
no results please try again
while not RS15.EOF
<%= rs15("option1") %>
set RS15 = nothing
set Conn = nothing
the <%= rs15("option1") %> is where you would subsitute the information you would like to display
there are a bunch of different ways to do this, but that is the one i had in one of my files.