A
Alex
Kind of a long question coming up! (I have included my
table structure).
Here is my table structure:
Registration: registration_id; client_id; course_id
Course: course_id; activity_id
Test: test_id; test_master_id; registration_id;
attempt_date
Test_Master_ID: test_master_id; test_name; activity_id
Questions: question_id; question; test_master_id;
Answers: answers_id; question_id; answer; test_id
So, basically, Test_master_ID is a table which contains
the type of test and information regarding that specific
test. Test table contains information regarding a
specific incidence of test taking e.g. on June 12 student
A took test 12.
Questions has all the questions in it, referring to the
test_master
Answers has the answers in it, referring to the questions,
and the tests table (the specific incidence).
I am trying to create a form whereby I can prompt the user
to type in the course number. Then, the form will pull up
all students in that course number. The form will one-to-
many with the test incident (I guess this has to be). The
attempt_date should automatically fill it. Then the user
can enter all teh answers against all the questions for
one particular test. By tabbing, the user should be able
tomove easily to the next studnet's recorsd.
I just cannot get this to work. It seems to need 3
forms/subforms and by the time I get down to the last one,
the fields won't allow any data to be input.
Any help, at all, would be much appreicated.
Alex.
table structure).
Here is my table structure:
Registration: registration_id; client_id; course_id
Course: course_id; activity_id
Test: test_id; test_master_id; registration_id;
attempt_date
Test_Master_ID: test_master_id; test_name; activity_id
Questions: question_id; question; test_master_id;
Answers: answers_id; question_id; answer; test_id
So, basically, Test_master_ID is a table which contains
the type of test and information regarding that specific
test. Test table contains information regarding a
specific incidence of test taking e.g. on June 12 student
A took test 12.
Questions has all the questions in it, referring to the
test_master
Answers has the answers in it, referring to the questions,
and the tests table (the specific incidence).
I am trying to create a form whereby I can prompt the user
to type in the course number. Then, the form will pull up
all students in that course number. The form will one-to-
many with the test incident (I guess this has to be). The
attempt_date should automatically fill it. Then the user
can enter all teh answers against all the questions for
one particular test. By tabbing, the user should be able
tomove easily to the next studnet's recorsd.
I just cannot get this to work. It seems to need 3
forms/subforms and by the time I get down to the last one,
the fields won't allow any data to be input.
Any help, at all, would be much appreicated.
Alex.