Select Multiple values in Drop down box

[tnguyen315]

Hi all,
I created a form in access 2007 font end and SQL 2008 back end. How do I create a combo box with selecting multiple values.

For instance, I have a table named "tblEmployeeInfo" and a drop down table named "tblSalesRegion".
"tblEmployeeInfo" has a field name "SalesRegion"...

"tblSalesRegion" has a field name "SalesRegion" with values:
West
East
EastCoast
South
Etc...

on the form, I have a combo box to select the SalesRegion value, but now it's only let me select one value at a time.
I would like to select some values such as "East, West, South"

I know access 2007 let you do this option but then I have SQL back end, not access...So I don't know how to do this...

Please help, I'm very appreciated.
Again, thank you very much.
Twee

 

[MajP]

Access 2007 and later lets you do this because it has a special field called a multi value field. It actually stores the data behind the scenes in a normalized system table. However, this does not work with a standard list but uses the multivalue field control. I am not certain, but doubt this is doable with a sql backend.

You could use code and write an event to concatenate your values. However, this is a bad idea because you violate database normalization. Working with that concatenated data becomes very complicated. It may look similar to a multi value field, but act very different.

You should be building a child table for regions linked to the main table. Then you can have a 1 to many relationship.