F
FrankieNap
I am quite new to Access, but have been teaching myself along the way.
I am putting together a database for my students and am having some
difficulty making my test assigner. Here are 3 tables of my database:
1. AT tutor student database : contains contact information about my
students, including a unique Student ID for each student.
2. SATITest : includes information on all of the tests each of my
students have already taken (including a StudentID and a TestID)
3. SATID : includes names of all of the available tests (TestID)
I have created an unmatched query which matches Tests taken from
SATITest to SATID and finds tests that each individual student has not
yet taken. I have set the StudentID as the parameter for the query.
I assign tests in a form in AT tutor student database using the query
as a drop down list to show availabletests, but instead of typing in a
new student ID each time I want to assign a test, I want the StudentID
to update automatically when I go from student to student so that the
query displays the available tests for each individual student.
Any advice?
Thanks,
-frank
I am putting together a database for my students and am having some
difficulty making my test assigner. Here are 3 tables of my database:
1. AT tutor student database : contains contact information about my
students, including a unique Student ID for each student.
2. SATITest : includes information on all of the tests each of my
students have already taken (including a StudentID and a TestID)
3. SATID : includes names of all of the available tests (TestID)
I have created an unmatched query which matches Tests taken from
SATITest to SATID and finds tests that each individual student has not
yet taken. I have set the StudentID as the parameter for the query.
I assign tests in a form in AT tutor student database using the query
as a drop down list to show availabletests, but instead of typing in a
new student ID each time I want to assign a test, I want the StudentID
to update automatically when I go from student to student so that the
query displays the available tests for each individual student.
Any advice?
Thanks,
-frank