Database search

[Guest]

Need help!

I have a database of products that I want customers to be able to search.
The database fields are:

CATOGORY :: SUB-CATOGORY :: PRODUCT DESCRIPTION

I want the customer to

1. 'choose' a catogory
2. 'choose' a sub-catogory (of the chosen catogory)
3. 'Search' for product name (of the chosen sub-catogory)

I have the database connection fine

QUESTION: Once they choose a catogory how do I pass that 'choice' to the
next look-up for it's particular sub-catogory, and again to it's product name?

Thanks!
Sondra

 

[Kathleen Anderson [MVP - FrontPage]]

You could start with this:
How to filter a database query using two drop down lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm



--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Guest]

I did fiond that page and have had successs WITH THE EXCEPTION of the last
part. All the choices go well, but now can't figure out how to search the
sub-catagories product descriptions?

Any thoughts?

Sondra

 

[Guest]

Hi Sondra,

Check out this link
http://www.javascriptkit.com/script/script2/multiplecombo.shtml