for example , i have country field drop down and city field dropdown like below ,
country City
IND Chennai
US New York
UK London
when i select IND from a drop down filter ,automaticllicay Chennai should be selected(displayed) in City dropdown filter .
Can anyone help me to do this .
Hi
Try this, I used lookups
<form>
<label>country_city</label>
<fieldset submitButton="false">
<input type="dropdown" token="country">
<label>field1</label>
<prefix>country="</prefix>
<suffix>"</suffix>
<fieldForLabel>country</fieldForLabel>
<fieldForValue>country</fieldForValue>
<search>
<query>|inputlookup country.csv |table country</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
</input>
<input type="dropdown" token="city">
<label>field2</label>
<fieldForLabel>city</fieldForLabel>
<fieldForValue>city</fieldForValue>
<selectFirstChoice>true</selectFirstChoice>
<search>
<query>|inputlookup city.csv |search $country$ | table city</query>
</search>
</input>
</fieldset>
</form>
country.csv
country
IND
US
UK
city.csv
country,city
IND,Chennai
US,New York
UK,London