Check all that apply data

[jwindon]

Not sure if the "Forms" forum was the appropriate place to put my post, but anyway.

I need to do something along the lines of:

Check all that apply:

Movies
Gardening
Music
ect. about 7 yes/no fields (or more later on?)

I can record that data in separate fields, but I am wondering if there is a better way to record multiple selections.

I've seen a lot of good advice on table/form contruction here before so I hope to get some good advice myself. Thanks in advance.

 

[Jack Cowley]

I would suggest individual fields. Much more flexible in my opinion. Lots of trouble if you put the selections all in one field as you have to dig them out again if you want to count how many 'Gardening' or 'Movies' items were selected. Never a good idea to combine data into a single field.

 

[jwindon]

So my making 7 yes/no fields was the "best" way to go. I'm so thrilled. Thanks for your quick response Jack.

 

[Drew]

for my 1p I would like to suggest a seperate table with person(?) id and selection as primary key, and a master table of available selections. if you're going to add/remove/edit more later it will allow you to add more choices without having to change any of the structure,

HTH

Drew