I am trying to create an online calendar system and have created two tables in ms access. first is a the calendar table containing the calendar id, name and date created. The second is a event table containing all the possible events entered into a calendar. This is one to many relationship, from calendar to event. I want to be able to create many calendars and view the specific events containing these. How do i go about creating the link between these, i have done the theory behind databases in uni but am having problems implementing them.
Also i want to be able to view these events in the order of time and date, how do you go about this in jsp.