Tami
If this is really the way you want to go then:
Call the checkbox field CBF1. I assume there will be some checkboxes
with more than one value checked. If not, the script can be shortened a bit.
Create 45 fields, named CBF1_ plus the contents of the appropriate
checkbox field, e.g. CBF1_Yes, CBF1_No, CBF1_Maybe etc.
Run this little script: Convert CBF1
Show All Records
Go to Record/Request/Page [First]
Loop
Set Variable [$ValueCount; Value:ValueCount (YourTable::CBF1 )]
Set Variable [$I; Value:1]
Loop
Set Variable [$Value; Value:Substitute (
MiddleValues ( YourTable::CBF1 ; $I ; 1); "ΒΆ"; "")]
Set Field By Name ["YourTable::CBF1_"& $Value; $Value]
Set Variable [$I; Value:$I + 1]
Exit Loop If [$I > $ValueCount]
End Loop
Go to Record/Request/Page [Next; Exit after last]
End Loop
Repeat the process for each of the different checkbox fields.
Ross
Tami Williams wrote:
Thanks in advance.
Using FileMaker 10 on MacOX 10.411 I need ideas on how to convert a
checkbox with approximately 45 different checkbox values, into 45
different fields on the same record.
There are about 44,000 records and more than one checkbox like this.
