Re: NEEDED HELP URGENTLY TO DUPLICATE THE SAME IDS FROM ONE ROSTER1 TO ROSTER2
Posted: November 23rd, 2017, 7:16 am
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.
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.