Filtering a drop down menu
I have a problem that I can't seem to wrap my head around. Just for background info., all pages were created with DataAssist 2. In the back end admin section, the administrator can insert event details through a form and then check one of two boxes that state whether the event is for Members or Non-members.
On the front end, when a Non-member proceeds to register for a Non-member event they fill out a form that gets emailed to the event host. In that form, I have a pull down menu that's dynamically pulling in a list of all the events so they can select the event they want to attend. The problem is that the list also includes the Member events. How do I go about filtering the list so that only Non-member events appear in the drop down menu?
Do I need a special column in my database so that when the admin checks the Member or Non-member box (on the back end insert page) a value is assigned? Then filter that value on the page with the drop down menu? I'm a bit lost in this department.