choosing mutiple values from a drop down list

  • Thread starter Thread starter Trying to Finish
  • Start date Start date
T

Trying to Finish

My database has many facilities that all use a combination of care and
supervision. How can I choose several values from a drop down list? Or...is
there a better way to do this?
 
Combo boxes are single-select.

You can select several values from a list box control if the MultiSelect
property is set appropriately.
 
Did you really say " ... a yes/no field for each type of care"?

As my grandmother used to say, "Heaven forbid!" This is the last thing you
want to do in a "relational database"! NEVER, NEVER store data in field
names, which is exactly what you have to do to do what you have recommended.

A much better structure would be a have a separate table where you map
facilities to Care and level of Supervision(as Steve mentioned) .

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Linq,

Creating a bunch of yes/no fields in a record is just poor database design.
What happens when you add a new type of care, or a new level of supervision;
you have to add more columns to your table, change all of your queryies and
forms, and reports.

Instead, with a relational data setup, you have a field for Facility,
another for Type Care, and another for TypeOfSupervision. You can use a
subform to enter the data. See Allen Browne's explaination at:
http://www.allenbrowne.com/casu-23.html

Dale
 
Back
Top