Tony, It looks like you are going to have to have more tables than you initially envisioned. I would have a student table, a class table, a test table, and tables to join them (student to class, test to class, and student to test to class) Just a very quick thought but I have done similar...