Hi All! I want to design a survey form for internal use in my organization in which has a requirement select district, county and village from a drop down combo box. I want to use an External select feature of the Excel file since there could be close to a 1000 villages in each county. Each village has a village code which uniquely identifies the village as opposed to names. I want to use names for the villages but once the user selects a village by name from the list of villages, both the name as well as the underlying village code should be stored in the Excel file.
I have found resources many resources on cascading select but no good ones explaining how the External Select works.
Can anyone guide me please?
Thank a lot!