Dynamic Option Boxes?

[sluggercoach]

Not sure my title is very good but... here is what I need to do...

I have a database with a form where a user will chose a specific zone (Zone 1, Zone 2, etc.). They can choose multiple zones. I want to be able to display all of the zones that they can choose from on the screen and give them the ability to choose multiple ones. I don't want to have a field in a table for each specific zone because the users can add new ones at any time so the list will be dynamic. So I essentially need to display a list of possible zones where they can choose multiple ones. I also need to store them in a table. I would like to store each selection in a table that has a one to many relationship with my main table. So, each of their selections would be a separate record in my table with an ID field that ties it to the main record. I have to be able to report by zone later on. Does any of that make sense? I think I need a list box maybe, displaying all possible zones. But, how do I get that list box to update my table with one item in each record?

 

[pbaldy]

Here's a way to add records to a table:

http://www.baldyweb.com/MultiselectAppend.htm