The specifications of the client have changed to the point where to get the effect I want I will need a list of lists within a participant’s records (IE: they’d have a list of records within their record).
So for example a participant might have:
College Courses attended
College - Glasgow Calidonian University
Course - Beginner's Spanish
Started - August 2010
College - Glasgow University
Course - Intermediate's Spanish
Started - August 2011
College Assessments taken
College - Glasgow Caliedonan University
Course - Beginner's Spanish
Asssment - Final Exam
Taken - December 2010
Mark - 80%
College - Glasgow University
Course - Intermediate's Spanish
Asssment - Final Exam
Taken - December 2011
Mark - 30%
Is there any feasible way of doing this in Participant’s database?