Multiselect

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

Guest

I'm trying to create a Multiselect function for a list box in a form which
has a subform. I've tried using both Simple or Extended, then selecting terms
from the list in one record but then uses that term for all records in my
database. Any idea how I can select different terms from my list box that are
pertinent to each record?
 
If you are attempting to store multiple values related to a single record,
you should use a subform that displays records in a related table. This is
similar to multiple order details related to a single Order. However, Access
2007 supports multi-value fields. Many of us will still use a related table
to store multiple records.
 
Sorry, I'm a novice and not sure what you mean by displaying records in a
related table. All I wanted to do was select one or more terms from a
pull-down list (which appear in both the main form and subforms).
 
If all you want to do is "select one or more terms" then you can use a
multi-select list box. However, if you want to store these values then you
need a related table.

For instance assuming you have a table of employees and want to store all of
their favorite colors. They may have from 0 to many favorite colors. You
would create three tables:

tblEmployees
==========
EmployeeID
.....

tblColors
==========
ColorID
......

tblEmployeeColors
===========
EmployeeID
ColorID
 
Back
Top