Really need help - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Really need help

lkkkeithlkkkeith Posts: 16Member
I am working an assignment which is a Sports Day Enrollment system for secondary school.
I have simply 3 tables:

Student([u]Sid[/u],class,clsNon,Sname,dob,House)
Event([u]Eid[/u],Ename,Grade)
Enrollment([u]Enid[/u],Sid,Eid)

Grade 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!!!
Sign In or Register to comment.