General DB design question

[eluser]bennyhill[/eluser]
I have a form with a multiselect element. They are storing 4 different conference locations and a member can attend multiple conferences. How would I store what conferences they are attending in the member's record in the DB? Would I use an enum datatype, or set? Or do I create a new table storing the member's attending which events?

[eluser]vitoco[/eluser]
i think that creating a new table to store the events that a member will attend it's the best way..cause in case that you need to save event related data, like assistance, the time of the suscription, delivery of gifts, it's simple as adding fields to the table....also manage and filter a record per member/event, it's way more easy that parse enum fields i think.

Saludos