Selecting multiple records in drop down

[rscott7706]

Hello all, have a question regarding multiple drop down selections. Could not find any answers in search or advanced search.

I am currently rebuilding a Chamber database that I constructed several years ago. Learned Access on the fly and never have become greatly proficient at it.

The Chamber is asking me to build a drop down selection list that several options may be selected. The table is business categories for the particular company. One business may need only one category, but another may need several.

I.E. - Automotive company has only "Automotive" linked to it. But Barona Casino has "Dining", "Hotel", "Entertainment", etc.

So, I want to be able to select one or more items, and construct a query the would repeat the companies that have multiple selections. The Access database is converted to MySql and uploaded to site.

It may look like this:

Joe's Automotive Automotive
Barona Casino Dining
Barona Casino Hotel
Barona Casino Entertainment

An example of what I have now is located at:

http://www.lakesideca.com/directory.php

I hope I gave enough detail and sufficient information to get started.

Thanks all.



rscott7706

[RuralGuy]

There is no MultiSelect ComboBox in Access. You would need to use a ListBox if you want MultiSelect.