1 Reply Latest reply on Apr 17, 2013 11:38 AM by philmodjunk

Previous Selections Seen

jwshelton22 Apr 17, 2013 3:37 AM

Title

Post

When a Student registers for classes, they can have a list of 1 to 12 based upon degree plan selected. When they complete selecting their classes they Submit their schedule. Admin only sees selected classes. This is working for the first Student, the next Student sees the entire list of classes has they should only the Selected fields marked as the first Student.

Tables: Classes, Students

thanks,

Jim

1. Re: Previous Selections Seen

philmodjunk Apr 17, 2013 11:38 AM (in response to jwshelton22)

     Looks like you need at least one more table:

     Students-----<Registration>------Classes

     Students::__pkStudentID = Registration::_fkStudentID
     Classes::__pkClassID = Registration::_fkClassID

     This way different students can register for different groups of classes by creating records in Registration that link the student to each of the selected classes.

     For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
Like Show 0 Likes(0)

Actions