Inserting multiple selections from list/menu
I'm creating an items_Insert page for an online clothes store. I want the customer to be able to search for clothes by occasion. I've created a table called Occasions with 2 fields (OccasionID and OccasionName) and a dynamic list/menu that allows multiple selections (one item may be suitable for working wardrobe or smart/casual for example). I want the OccasionName(s) to be inserted into the items table under 'ItemOccasion' as a comma separated list. Could you let me how I need to adjust the insert code to all for this.