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

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



--

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


"Sondra" <(E-Mail Removed)> wrote in message
news:1574D719-1E8B-471B-B687-(E-Mail Removed)...
> 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

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

"Kathleen Anderson [MVP - FrontPage]" wrote:

> You could start with this:
> How to filter a database query using two drop down lists....
> http://www.spiderwebwoman.com/tutori...ledropdown.htm
>
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "Sondra" <(E-Mail Removed)> wrote in message
> news:1574D719-1E8B-471B-B687-(E-Mail Removed)...
> > 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
>
>
>

Hi Sondra,

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

"Sondra" wrote:

> 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
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
> > You could start with this:
> > How to filter a database query using two drop down lists....
> > http://www.spiderwebwoman.com/tutori...ledropdown.htm
> >
> >
> >
> > --
> >
> > ~ Kathleen Anderson
> > Microsoft MVP - FrontPage
> > Spider Web Woman Designs
> > web: http://www.spiderwebwoman.com/resources/
> >
> >
> > "Sondra" <(E-Mail Removed)> wrote in message
> > news:1574D719-1E8B-471B-B687-(E-Mail Removed)...
> > > 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
> >
> >
> >