Multiple selections within an Option Group

K

Karen

I have an Option Group on my form with 15 choices to be picked from.
One choice or selection can be made now.
My "users" would like to be able to select more than one choice.
Is this possible in an Option Group? If so, how do I set it up? If I cannot,
what would you recommend for multiple selections? (to be saved in a field)
The information would have to be pulled from the tables to be generated in a
report.
Thank you
 
D

Douglas J Steele

Multiple choices should not be stored "in a field": they should be stored as
multiple rows in a related table. Storing multiple values in a single field
is a violation of database normalization principles.

Take a look in the Northwinds database that comes with Access. Look at how
there's a form and subform for Invoices and Invoice Details.
 
Top