Linked drop down lists

[Pete Casey]

Can anyone tell me how I go about making one list in a form only show
relevant details depending what the user chooses in the preceeding list box.
In other words.

Drop down list 1:

This list has a list from the database populated with categories.

Drop down list 2:

This list has the relevant subject headers for the relevant category chosen
in drop down list 1.


I assume it isn't the SQL that's the problem as all information is held in
one table. I just need help with the ASP for this.
Thanks in advance.

[Ray at]

See here for links.
[url]http://www.aspfaq.com/show.asp?id=2270[/url]

Ray at home

"Pete Casey" <oipete@blueyonder.co.uk> wrote in message
news:Moflc.7552$H53.212@pathologist.blueyonder.net ...

> Can anyone tell me how I go about making one list in a form only show
> relevant details depending what the user chooses in the preceeding list

box.

> In other words.
>
> Drop down list 1:
>
> This list has a list from the database populated with categories.
>
> Drop down list 2:
>
> This list has the relevant subject headers for the relevant category

chosen

> in drop down list 1.
>
>
> I assume it isn't the SQL that's the problem as all information is held in
> one table. I just need help with the ASP for this.
> Thanks in advance.
>
>

[Pete Casey]

Thankyou very much. Thats exactly what i was looking for.
Cheers