I think my problem is a very basic one, however being a true beginner I couldn't find a solution.
Here it is,
I have an external database (csdb) created using excel2cspro, containing partial cases with enumeration areas, addresses and so on.
Each batch of these cases is assigned to a different interviewer through an interviewer ID.
For each interviewer, I need to load (at once) all of the cases corresponding to their ID in order for them to complete the interview.
The loading needs to happen right after the launch of the app, so the interviewer can choose whether to start a new questionnaire or complete one of the loaded cases.
The loading needs to happen only once, so that any changes to the previously loaded data is preserved.
You do not need to have all cases loaded at the same time. See the documentation for Loadcase. For a dictionary, 1 case is loaded into memory at a time, with that setting the values for the variables of that dictionary.
You do not need to have cases loaded in order to have the user select them. For a good example of how to do this, see the Examples folder that comes with CSPro, at examples\1 - Data Entry\CAPI Census\Menu. The menu application in the example shows how to make a valueset with all valid household IDs, then load whichever case is selected when the user chooses to complete it. Try examining this example to figure out how it works, and implementing the same feature for your own application.