i'm developing a student database for a college to hold student, course and class information.
Students have a choice of 4 different classes per block, and there are 3 blocks a year, so they will get 3 choices of 4 classes per year.
I need a form that will hold this information that i can view all the classes being taken that block, and to be able to store information of the classes taken in a previous block.
In my ClassAssignment table, I have these fields
{AssignmentID,Option_ID,Student_ID,Block,Period}
To do what im planning would i be better to have {Period1,Period2,Period3,Period4}?
I really can't figure out how to store this information so any advice you guys can give me would be great!