Hi all,
I am building a conference scheduling database. I am trying to visualize how to set up this particular concept:
I have the following tables:
Conference_Main (overarching Conference)
Conference_Day (identifies how many days conference is, which will have different people going to it, different topics, etc.; foreign key link to Conference_Main)
Conference_Agenda_Item (overall agenda of the conference day (i.e., start time, end time, presenter(s), etc.); foreign key link to Conference Day)
Do I need to have an Overall_Agenda table, or can that just be a report? The goal is I want a user to be able to click a "View Agenda" button on any particular Conference Day and be shown a report of that day's full agenda. Example:
Conference_Main: Job ConferenceConference_Day: Day 1 <button to view entire agenda>
Conference_Agenda_Item: Resume Writing, 8 am to 10 am
Conference_Agenda_Item: Writing a Cover Letter, 10 am to 12 pm
Conference_Agenda_Item: Lunch, 12 pm to 1 pm
Conference_Agenda_Item: Dressing for Success, 1 pm to 2 pm
Conference_Day: Day 2 <button to view entire agenda>
Conference_Agenda_Item: Interview Process, 8 am to 10 am
Conference_Agenda_Item: Selecting Benefits, 10 am to 12 pm
Conference_Agenda_Item: Lunch, 12 pm to 1 pm
Conference_Agenda_Item: Telecommuting, 12 pm to 1 pm
The above is a simple/rough concept, but should visualize what I'm trying to do.
It seems like what I need is just a report that consists of the individual agenda items that keys in on the Conference_Day foreign key, but I can't get it in my head what that should look like. I guess my question would be is where the "<button to view entire agenda>" is, should that link to a report, and on the report, I would have a "View/Edit" button linking to a form for the individual agenda items?
This is my first database, so I apologize if this is way too obvious for some of you guys! I'm just unsure that if the Overall Agenda should actually be a table what information would need to be included in something like that. Any help appreciated!