Is this an Append Query?

[Chip]

I have a table that is called tblReservations. This table has 3
fields. AutoNumber, Student and Exam. The Students are in a table of
their own. The Exam is also ina table of its own. The exam is an
event.

What I want to do is to Automate the Reservation process. Students
are eligible for the exam, if they say complete the class, which is an
attribute of the Students. I can easily run a select query to limit
my students. What I want to have happen is write the students name,
and then assign him a testing event. An Append Query doesnt seem to
fit but I'm not sure either.. Does that make any sense??

 

[John W. Vinson]

I have a table that is called tblReservations. This table has 3
fields. AutoNumber, Student and Exam. The Students are in a table of
their own. The Exam is also ina table of its own. The exam is an
event.

What I want to do is to Automate the Reservation process. Students
are eligible for the exam, if they say complete the class, which is an
attribute of the Students. I can easily run a select query to limit
my students. What I want to have happen is write the students name,
and then assign him a testing event. An Append Query doesnt seem to
fit but I'm not sure either.. Does that make any sense??

A Form with a Subform would be typical for this purpose. If you're trying to
assign multiple students to one exam you could use a Form based on Exams, with
a subform based on tblReservations. On the subform you could have a Combo Box
based on the Students table to select each student. The combo could even be
based on a Query excluding those students who have already taken the exam (or
are otherwise ineligible).