Check all that apply

[Guest]

In Filemaker Pro, I can create an option group, whereby if I choose radial
buttons it will only allow one option to be selected, but if I choose check
boxes, it will "check all that apply", and will actually place that text into
the field.

In Access, Option groups only allow for one option to be selected, and
records it as a number.

If I have a list of choices, and I want the user to check all that apply,
must each choice be its own field, or is there a way to create one field, and
all answers that are checked get placed into that field?

Thanks
NB

 

[Douglas J. Steele]

Realistically, Filemaker Pro violates the rules of database normalization
when it allows you to store multiple values in a single field. The proper
way to do it is to have a second "child" table related to the first table,
with each choice stored as a separate row in the child table.