Multiselect

[Mozy]

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?

 

[Duane Hookom]

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.

 

[Mozy]

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).

 

[Duane Hookom]

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