I am new to Access! I am trying to build a database to manage event ticketing/attendees etc. Whilst I have, so far, not had a problem with creating a table of attendee information, also of individual events (name, location etc), there will be occasions with some events when optional questions will need answers. For example "will you be requiring lunch"?
Should I add these questions as fields in the "Events" table or create a separate table of optional questions? I will need to be able to access the options when I eventually create a switchboard to navigate the database.