foreign key creation in jsp and ms access

Hi, 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. Thanks Damien

Originally posted by damien farry:Hi, 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. Thanks Damien

Hi u can link the two tables im MS Access. Open MSAcess and goto Relationships and link the fields between the 2 tables.AS easy as that!!! Regarding viewing events in a particular order user the "order by" class in the SQL statement Hope this helps Regards Hemanth