I built a flat file database by exporting records from Filemaker Pro. One of the fields contains about 10 checkbox options.

After exporting, I found that the checkbox values within the field (of the database file itself) are separated by a box. No matter what I try, I cannot translate the box into an ASCII character.

The example in the download of dbman has only a single value in the checkbox example field.

Can anyone tell me what the little box is and/or send me an example of a database file (please make it small) with a checkbox field with multiple values?

Thanks!

In html forms, when you want to make a field have more than one option, but only one option can be chosen, you need to use a radio button field. The checkbox is a "Yes/No" sort of thing.

If you want to make more than one option possible within your 10 possibilities ("option1 and option3 and option7" for example), you'll have to define a field for each of the options. Then you can use checkboxes for each one.

Was that clear? I'm not sure I explained that very well. If I didn't ask away.



------------------
JPD