Multiple Value Entry

[RL Joneson]

I want to enter multiple values in one database field. For instance, an online store product that comes in 5 colors. I want the product insertion form to contain checkboxes of color names. Maybe 10. Red, pink, blue, etc.

Then have the user who is inserting the product check all the applicable colors to the specific product and store all the values under one name. Say productColors. I'll then set up a dynamic drop down menu on the product page that will retrieve the specified colors for that product.

Not sure how to do this. Thanks!

[Twey]

For a limited set of possible values, I would recommend a bitset.