CSPro Users Forum

Hi, I've a question about this topic. I've a liste of villages and investigator and I need to fill them automatically in a field when I select the code of village.

Every investigator will work in a one or two village.
thank you in advance

I would use a lookup file to do this. Create an Excel spreadsheet with the village code in one column and the investigator name in the other. Use the Excel2CSPro tool to create a data dictionary and data file from the Excel spreadsheet. Add the dictionary you create as an external dictionary to your data entry application. Then in the logic of your application after you capture the village code use loadcase() with the village code to retrieve the investigator name from the lookup file. There is a video on lookup files that you might find useful: https://www.census.gov/population/inter ... pro13.html