Option Group on a Form

[n]

Hello,

I have two questions:

Q1.
I am trying to create an option group where one can choose
from 8 different options and is allowed to only select up
to three of those options. How do you allow it to pick up
to three options?

Q2.
My option group looks something like the following:
A- B- C-

etc. where each of the letters has a check box by it. If I
am trying to make each letter represent a message that
will pop up later in a report how can go about doing that?

Thank you,
n

 

[Rick Brandt]

Hello,

I have two questions:

Q1.
I am trying to create an option group where one can choose
from 8 different options and is allowed to only select up
to three of those options. How do you allow it to pick up
to three options?

Sorry, an OptionGroup only allows one selection because it has to return a
single value to the underlying table field. What would the value be if you
selected more than one?

You could have CheckBoxes individually tied to separate fields in the
table, but that would be non-normalized and would be difficult to limit the
selections to only three.

Sounds like maybe you need a related table instead.