Select Multiple Options

  • Thread starter Thread starter Marie
  • Start date Start date
M

Marie

My tables look basically like:
TblCustomer
CustomerID
Customer

TblOption
OptionID
Option

TblCustomerOption
CustomerOptionID
CustomerID
OptionID

A customer can select one to seven options. My main form is based on
TblCustomer and there is a subform based on TblCustomerOption. The main form
and subform are linked on CustomerID. In the subform I would like to show
all seven options with a Checkbox beside each option where the option(s) the
customer selected can be checked and a record is created in
TblCustomerOption for each option checked. Further, I would like to show the
options in two columns with the first four options in column 1 and the
remaining 3 options in column 2.

Can this all be done? How?

Thank you very much,

Marie
 
Back
Top