Display only available options in list box

[alan_grn]

Is it possible to set a list box to display only the available options?

E.g IF I have two list boxes of for Country and anotehr for city, I only wnat to show the cities that a related to the country in the list box.

[#2]

you have two option:

1) Set "Hide Excluded Values" from General Tab about properties of your listbox, but it works only if you click on the listbox.

2) Modify the script using this step :

• LOAD Country LIST
• LOAD CITIES List whit this clause "WHERE EXISTS(COUNTRY_FIELD)" when you fetch data about the cities.

By this way, You will get only cities related to your known countries