aspose file tools*
The moose likes JDBC and the fly likes foreign key creation in jsp and ms access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "foreign key creation in jsp and ms access" Watch "foreign key creation in jsp and ms access" New topic
Author

foreign key creation in jsp and ms access

damien farry
Greenhorn

Joined: Mar 22, 2001
Posts: 6
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

Joined: Mar 15, 2001
Posts: 55
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: foreign key creation in jsp and ms access