I have 3 Tables linked by Student ID:
Table 1-Login
ID-access autonum
LName
FName
StudID-Primary Key
GradeLevel-Lookup Field(Fresh,Soph,Jun,Sen, Grad)
Table 2-ExamInfo
IDID-access autonum
ExamID-Primary Key
ExamName
ExStudID-Foreign Key
ExamDate
ExamLocation
Examiner
Table3-Answer
AnswerId-Primary Key
AnsStudID-Foreign Key
ExamId-ForeignKey
Answer1-LookupList 3 possible Answers
Answer2-LookupList 3 possible Answers
Answer3-LookupList 3 possible Answers
what is the best way to create a form for this test. There are 18 Questions and each Question has 3 possible answers the student will select one answer per question. Any Ideas???
Thanks!!