Need confirmation on Option Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is a Tool Request for Quote (based on table tbl_RFQ_Tool).

I have a grouping "Engraving" that has 5 options to choose from Cust P/N,
Cavity #, Date Code, Recycle Code and Other. They can check 1 or all 5 - is
there a way to use the Option Box, is that a 1 selection deal? Or, do I have
to make 5 Yes/No fields in the table? The option group would be easier
because in addition to these I have 6 other groupings with 56 options all
together which if I have to make fields would make my table huge which I try
to avoid as much as possible but if this is the best normalized way I will do.

Thanks!!
 
SMac said:
I have a form that is a Tool Request for Quote (based on table
tbl_RFQ_Tool).

I have a grouping "Engraving" that has 5 options to choose from Cust P/N,
Cavity #, Date Code, Recycle Code and Other. They can check 1 or all 5 -
is
there a way to use the Option Box, is that a 1 selection deal? Or, do I
have
to make 5 Yes/No fields in the table? The option group would be easier
because in addition to these I have 6 other groupings with 56 options all
together which if I have to make fields would make my table huge which I
try
to avoid as much as possible but if this is the best normalized way I will
do.

Thanks!!
Click to expand...

Unfortunately, option groups are built to allow only one selected item at a
time. You could group your checkboxes and draw a rectangle around them to
make it look like an option group.
 
Back
Top