Value List from Single Mysql Field

[rivet]

Current Setup:

FMP Client --> FMP Server -- > ODBC --> MySql

NEED

For each value list, I would like to have a single field, in a prefs table in the mySql db.

SO FAR:

Although this concept works well within FMP, I am having trouble with the above arrangement. I believe it is the character returns.

In FMP I setup a field with a control style of Checkbox Set., but on the layout it shows a single checkbox, that when clicked, it populates the field with all items from the MySql field.

Any suggestions?