File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: foreign key creation in jsp and ms access
 
Similar Threads
how to do it?
Very newbie question on tables please
how to do it?
The Rookie Throws in the Towel (Kind of)
how to do it?