ComboBox or <SELECT>

[TudorSmith]

Hi Folks

How do I refresh a DropDown box on an ASP page?

I have three <SELECT> drop downs:

<COMPANY>
<SITE>
<TRADING OUTLET>

At the moment, each <SELECT> is populated form a recordset e.g. "SELECT * FROM tblCompany ORDER BY CompanyName"

The tables are linked i.e. tblSite contains the FK CompanyID and tblTOulet contains the FK SiteID.

So, what I need to accomplish:

When the user selects a comapny, I'd like only the sites belonging to that company to be present in the SITE list. Then, as the user selects the Site, I'd like only those Traing outlets belonging to that site to be present.

Is this do-able in one page or will I need about three pages to accomplish this.

Thanks in advance

Tudor

birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))

 

[DreXor]

there's many of these threads pertaining to the same desired effect, search for keywords on "multiple combo" or "multiple dropdown