Populate a 2nd drop-down list using the 1st

[delorfra]

Hi,
in a form, I want to select the supplier in a first drop-down list and then the second list to be populated with items linked to the supplier selected; this to avoid retrieving the whole huge items recordset of 10,000+ records when downloading the form at first.

Is it possible to do this without downloading the form again once I have selected a supplier ?, that is, just refreshing the second list items itself but not the whole page ?

Thanks
(IIS 4-ASP 2/ADO 2.1/Oracle 8.04)
blygman@hotmail.com

François

 

[GIGN]

You need to filter your recordset:

http://www.devguru.com/Technologies/ado/quickref/recordset_filter.html

<bb/>

 

[delorfra]

Thanks,

but as it uses ADO on the server side, it means It doesn't spare me downloading the page once i have selected a supplier in the first list, or does It ?


blygman@hotmail.com

François

 

[WMitchellCPQ]

I dont think so.
You'll have to reload the page again.