CSPro Users Forum

If I am understanding your spreadsheet correctly you want to list the crops for each holder. I would implement that with a checkbox for each holder where the options in the checkbox are for the crops. So you would have a roster with two variables: holder id and crops checkbox. This will be easier than dealing with spaces in the roster.

An alternative to using checkboxes is to use a repeating form (repeats once per holder) with a roster for the crops. In the dictionary you would have a record with multiple occurrences (up to max number of holders) that has a holder id with one occurrence and an item for the crop code with multiple occurrences (one per crop type). Drop this record onto a blank form and it will become a repeating form with a roster on it for the crops.

Josh,
Since, I don't have much understanding of check Boxes as solution, I tried the second solution but was unable to drag the items on the form successfully. So I am sending you the dictionary created for your attention.

Drop the crop code first and then the holder id.