>Michelle
>
>>Because there's more than 2 things on the checkbox. There can be up to 250. It's much easier to save it as a string and do the manipulation than to try and maintain a table with 250 fields that may or may not be there.
>
>Just something to think about. This sounds like it might be a candidate to be a separate child table. If it's a sparse subset you might save some storage. A child table would definately be easier to make queries against instead of testing positions in the string.
>
>Glad you got it working.

If the checklist were set at design time, then yes, that would be better. But Converting records into fields is too much of a headache.

-Michelle