checking multiple check boxes

[Guest]

I am trying to create a form that has several different check boxes for one
catagory. I would like to be able to check more than one. Is that possible,
and if so, how?

Thanks,
MWN

 

[manningfan]

It's only NOT possible if you put an Option Group on the form. You can
have as many independant checkboxes as you want if they're not in an
Option Group.

 

[Guest]

How exactly then do I do check boxes so that they will be bound to the
specific catagory in the table. Right now, when I click the check box and go
to a new entry, the check box stays the same and doesn't transfer over to the
table.

 

[Pat Hartman\(MVP\)]

If you are asking how to store multiple selections in a single column, the
answer is you can't with any standard object. Relational databases prohibit
storing multiple values in a single column so you will find no tool in the
interface that supports that functionality. When you have more than one of
something, you have "many" and "many" requires the use of a second table
which will hold each item in a separate row. If you want to use a
multi-select list box, you can write your own code to collect the selected
items and store them in the same column and conversely to populate the
multi-select listbox as each existing record is displayed but I don't
recommend it.