File Import to populate multiple checkboxes

[zooachtiv]

hello -

i have a file that is in the form of a SSN,Scholarship_code

each line contains 1 ssn and 1 scholarship code..

if a student has 2 scholarships he has 2 lines.. each w/ different code (D,E,M,I etc etc)

555-55-5555,A

555-55-5555,C

666-66-6666,A

777-77-7777,M

how can i get the checkbox field to populate with multiple checks??

there are 18 different scholarships avail. and i created a single checkbox field with the 18 different possible values..

if i import the file, and match columns, i only get the first 555-55-5555,A checkbox..

what do i need to do to have it check through each line and thus check multiple boxes??

thanks!

-tom

[Pupiweb]

Try using a "middle" file, in which you import the data

Relate the file to the main file on the SSN number

After the import run a looping script:

Go to record first

Loop

Set field (

RelationshipOnSSN::CheckBoxField,

If (isEmpty (RelationshipOnSSN::CheckBoxField), ScholarshipCode, RelationshipOnSSN::CheckBoxField & "PP" & ScholarshipCode)

Go to record next, exit after last

End loop

"PP" stays for a carriage return