Multiple selections within an Option Group

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to select more than 1 option from an option group 2
Option Group not resetting 1
Option Group - Multiple Selections 2
Add another option button to an option group 2
Multiple Selections 5
How do I allow multiple selections in an option group? 1
Access Create option group without using wizard? 2
How do I allow multiple selections within a Combo box in Access? 1

Top