Reports with Value List

[uclacnsi]

Hi,

I have a database of client profiles. To make data entry easy, I used a value list and check boxes for one of the fields, "School". The values include: Sch of Med, Sch of Dentistry, Sch of Engineering, etc.

It is possible that some clients have multiple school affiliations.

What I would like is to be able to split the field into separate records, the same way you can split repeating fields into multiple records when you import them. My template is set up to make the report if I can split the field.

Thanks

[comment]

You could define a repeating calculation field =

GetValue ( Extend ( School ) ; Get ( CalculationRepetitionNumber ) )

then import this field, along with ClientID, into your new table.

[uclacnsi]

Thanks, this is starting to do what I need. But it only returns the first checked value, not multiple values.

what exactly is the get(calculationRepitionNumber) function doing?

thanks, again

[comment]

it only returns the first checked value, not multiple values.

I don't think so - see attached.

what exactly is the get(calculationRepitionNumber) function doing?

http://www.filemaker.com/11help/html/func_ref2.32.18.html#1028830

Checkbox2Repeats.zip

[uclacnsi]

Thanks for your file.

OK, I recreated your file from scratch and it looks like everything is exactly the same, yet i only get the first check box in the calculation field. Where am I screwing it up?

Thanks gain for the help.

checkbox.fp7.zip

[uclacnsi]

Got it!

I needed to put show repetitions 1-5 on the inspector menu

Thanks for all your help!