I am working an assignment which is a Sports Day Enrollment system for secondary school.
I have simply 3 tables:
Student(Sid,class,clsNon,Sname,dob,House)
Event(Eid,Ename,Grade)
Enrollment(Enid,Sid,Eid)
Grade(by calculating the age) A>=16 B=14-15 C<=13
But my assumption is that each student can only apply for 3 events.
How can I display the corresponding events for the student to choose and limit his choices to 3?
Can anyone help me? I am frustrated of failing to make it out.I am using Access 2003.
Thanks a lot!!!