I cannot get this to work, so if someone can confirm that Caspio does not support such functionality, I'd be appreciative.
I've got two search fields - state and city - both of which are populated from the main table with distinct values. State is required. When city is configured as a normal drop-down, I can configure it to allow "any" city relative to all cities in all states. When configured as a cascading drop-down, I appropriately must chose a single city from among those cities in the selected state. But what I cannot seem to do is to combine cascading cities with the "any" option -- i.e. I want the user to be able to select EITHER a single displayed city in the selected state OR "any city" in the selected state.
Thank you.
UPDATE: My mistake, this functionality does exist and works perfectly. Somehow my drop-down was losing the normal required settings to support "any". Sorry to trouble you!