View Single Post
  #4 (permalink)  
Old January 8th, 2007, 01:48 PM
code_lover code_lover is offline
Authorized User
Join Date: Jan 2007
Location: , , .
Posts: 46
Thanks: 2
Thanked 1 Time in 1 Post

Okay this makes the picture a bit clear now.You have to have a third table here i.e. Classes(ClassID,Class)(Total Tables:3).You are suppose to enter basic student details just once in the Students section(i.e. student name, id)in the Students table right.
And for the StudentSchedules section you have to have 2 combo boxes populated with StudentID and a ClassID in your ASP page.Whenever a user clicks or selects the StudentID and ClassID, the names of the student and class should appear.
Remember the more tables you create and the more narrower your tables are going to be does make your application's performance better.
I hope this helps and you get the idea. Keep on going're on the right path, wish you best of luck!