I think I am at the stage now where I can't see the wood for the trees!
I have a one table db with the following fields ID(Autonumber)(PK), RollNumber,LessonNo,DataField1,DataField2,DataField3.....etc.
I have a unique index on RollNumber and LessonNo, the idea being that each RollNumber can...