Re: one event, miltiple dates and times-
To track the name of the event, create a 2nd table with 2 fields, EVENT_ID (Autonumber field), and EVENT_NAME (Text field default is 50 characters). Call this table "tblEvent".
Create a table with 4 fields, EVENT_ID (Number field set to INTEGER), DATE (Date/Time field set to LONG DATE), DOORS (Date/Time field set to MEDIUM TIME), and DOWNBEAT (Date/Time field set to MEDIUM TIME). Call this table "tblSchedule".
In the relationship settings, link the two tables on EVENT_ID.
Then, to input events, you'd have to create a form that will allow you to add the EVENT_NAME (thereby creating the EVENT_ID) and then a form that will allow you to select the EVENT_NAME (and in the backgroud the EVENT_ID), and schedule the event. On this form you would take the EVENT_ID from the Named Event in "tblEvent" and store that in the EVENT_ID in "tblSchedule".
Hope this helps...
"There's never enough time to do it right, but there's always enough time to do it over!"