NEW TO ZOHO and SEEKING HELP

NEW TO ZOHO and SEEKING HELP

can you use arrays for table selections on a form

i.e. I have a table containing 29 districts I want to choose one district, this would allow the regions tables of which there are 29 to be hidden and the chosen region from the district table to be visible and enabled

as it is the following code is being used but is very cumbersome

if input_REGION_SCOTLAND == "<selection1>"

{
show DISTRICT_<selection1>
hide DISTRICT_<selection2>
hide DISTRICT_<selection3>
hide DISTRICT_<selection4>
etc
}
if input_REGION_SCOTLAND == "<selection2>"

{
hide DISTRICT_<selection1>
show DISTRICT_<selection2>
hide DISTRICT_<selection3>
hide DISTRICT_<selection4>
etc
}
etc etc

this is no use as there are 29 values in the REGION_SCOTLAND table


Thank YOU in advance Tommy

and I have