G
greg
I am trying to create a database where students can select course seminars. I
have one table containing all the information of the different seminars, and
one which contains all the fields for the student’s schedule. There are seven
queries corresponding to the seven scheduled times for seminars. Each time
slot has three classes available. I want the student to be able to select a
seminar subject and have the presenter and location of the seminar filled in
automatically from the data presented from the queries. The form related to
the student schedule searches the available classes for the appropriate times
but only updates the one field “topic†how do I get the two other fields to
update without the student selecting each individual field?
have one table containing all the information of the different seminars, and
one which contains all the fields for the student’s schedule. There are seven
queries corresponding to the seven scheduled times for seminars. Each time
slot has three classes available. I want the student to be able to select a
seminar subject and have the presenter and location of the seminar filled in
automatically from the data presented from the queries. The form related to
the student schedule searches the available classes for the appropriate times
but only updates the one field “topic†how do I get the two other fields to
update without the student selecting each individual field?