Hi,

I have two check boxes and a dropdown list.one for US and one for Canada.when somebody checks US, the dropdown should be populated with all the states in US.when somebody checks Canda,the dropdown should be populated with all the provinces in Canada.I have all the states and provinces in a reference table.

I am not able to accomplish this.should I use javascript? I only know populating a dropdown statically or dynamically.Can somebody put some thoughts into this.

Thanks.

This message has been edited. Last edited by: Kerry,

HTML Composer implements the concept of "chained controls" but that feature is available, I think, as of WebFOCUS 7.6.9.

I don't know if there's any similar to that for your version of the product though.

you can use 2 static drop down list box. One for US and another for Canada. Using style.visibility property, toggle the drop down based on check box selection.

You can also use AJAX to refresh the dropdown based on checkbox seletion. In this there are 2 methods.
1. For every action on checkbox, you can send a request to webFOCUS and reload the dropdown.
2. During page load itself, you can bring data for both the selection and store it as javascript object (xml file, array, etc). During checkbox selection, query against this array and refresh the dropdown.

I recommend second option, as this will take less time to refresh the dropdown.