I want to create a database which i want to track pupils for a period of years for a particular school.
I have the fields but dont know how to start. The fields are
Division,District,District Code,Zonecode,zone,School,SchoolCode,Surname,firstname,Year, Code(district,school,pupil),Pupil code, Sex,Age,Repetition,Class,Number
Class New Entrant First Repeater Second Repeater
1 2012 2011 2010
2 2011 2010 2009
3 2010 2009 2008
4 2009 2008 2007
5 2008 2007 2006
The logic is a Class 1 pupil in 2012 is a new entrant, a Class 1 pupil in 2011 is a first repeater, a class 1 pupil in 2010 is a second repeater.
Would you please help me with the database schema, and a vb code and a data entry interface
Code block added - OriginalGriff[/edit]