selecting multiple choice

  • Thread starter Thread starter John C.
  • Start date Start date
J

John C.

I'm trying to select mulitple options for a record. From what i've
researched the simplist way is to have 2 tables. I'm just not sure how to do
this in a form. As I add new records for the main form I need to select
mulitple options from another table/form. Is there a way to show the options
and simply check them? Any help would be appreicated. Thanks.
 
JOhn,
You question is too general in nature to understand what it is you are
trying to do. Your assertion that the simplest way to select multiple
options for a record is to have two table is incorrect and indicates your
database design needs some rework. If you can be more specific about your
goal, perhaps we can offer a suggestion.
 
Sorry. I have a database with customers that can have several options
associated with their account. i.e. ABC Company has 3 delivery options. I
would like to select mulitple options for one customer. The delivery options
in these case would be from another table/form of predefined options. Hope
this is clearer. Thanks.
 
How do you identify a delivery option?
How do you know how may delivery options a customer can have?
What do you do with delivery options?
 
When the account is established and the data is entered we would ask if the
customer would like there deliveries in the hand delivered in front, back,
fedex, UPS etc.

As far as how many, the most I've run into is 4 could be more could be less.

I store to data for information and to run reports.
 
Realistically, you've got a many-to-many relation between Customer and
Delivery Options: one Customer can choose to use multiple Delivery Options,
and one Delivery Option can be used by mutliple Customers. To handle
many-to-many relations, you need to introduce a third table which has the
combination CustomerId and DeliveryOptionId as its primary key.

Take a look in the Northwind Traders database that comes with Access. This
is the same idea as with the Orders and Products tables: one Order can
contain multiple Products, and one Product can be contained on multiple
Orders. To handle that, the Order Details table was introduced.

To handle updating the tables, typically you use a form and subform. The
Customer details would appear on the parent form, and the form used as a
subform would be bound to the third table you created (usually with a combo
box that uses the Delivery Options table as its row source to make it easier
to select the options of relevance). Again, you can look at the Orders and
Orders Subform forms in Northwind for an example.
 
Back
Top