View Single Post
  #8 (permalink)  
Old July 1st, 2009, 05:29 AM
peace95 peace95 is offline
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default foreign key works but other data wont appear


You need to use the junction table between your Student Tasble or Entity and the Course Table or Entity. Remember to remove the Student ID from the Course Table. Follow instructions in previous response.

I forgot to mention, the tables on the right and left of the junction table MUST exist or be defined in the database BEFORE defining the junction table, the one in the middle,. Also in your forms you can use the Book, Author, Customer and Course Tables as LOVs after you populate them.

Redefine your RDBMS schemes...... Yes you are very close.....Don't Give Up!!

Hope This Helps.
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.
Reply With Quote