Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

foreign key creation in jsp and ms access

 
damien farry
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

------------------
 
hemanth kumar
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic