I have an inherited FM db running on 5.5. We have a script that imports from a SQL database capturing web data. A new piece of data will be in mult-choice checkbox format. I can do this the easy way, I think, which is to just grab all choices into one text field in FM from the single SQL field. But is there a way I can map it into a checkbox-formatted Filemaker field for display for my users?

Hi, Bob. If you import the data:

A

B

C

into a field with checkboxes on it for A, B, and C, then all those boxes will be checked. (This will also work if the items are "out of order," that is, if the order is BAC instead of ABC.)

Alternatively, if you have to import the data as "ABC" (with no paragraph markers), maybe you could script your import to add the paragraphs after importing.

HTH,

Jerry