Title
Previous Selections Seen
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
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