J
Jim Lehmann
Greetings all. I'm working in Access 2003. Using the Students and Classes
example, I have the tables: Students, Classes, and ClassLoads (students and
the classes they are taking). Then I create another table, Papers, to hold
the titles of papers written by each student for each class. In a Form,
based on the Papers table, designed to enter the titles of papers submitted,
I want my selection of a student from a combo-box in field #1 to limit the
choices available in the Class combo-box (field #2) to only those classes in
which the student is enrolled (rather than showing all classes from the
Classes table). Is that possible?
example, I have the tables: Students, Classes, and ClassLoads (students and
the classes they are taking). Then I create another table, Papers, to hold
the titles of papers written by each student for each class. In a Form,
based on the Papers table, designed to enter the titles of papers submitted,
I want my selection of a student from a combo-box in field #1 to limit the
choices available in the Class combo-box (field #2) to only those classes in
which the student is enrolled (rather than showing all classes from the
Classes table). Is that possible?