relationship

[_samuel_]

I'm a beginner trying to establish a FM database for our school. Our teachers teach private lessons to students and I need to generate monthly contracts for them. I have four tables: FACULTY, STUDENTS, PAYMENTS and CONTRACTS. I would like to be able to go to the "student" layout and choose each teacher's students by entering a certain code and when I go to the "contract" layout enter that code and I get that teacher's student list. How do I do that?

Edited February 3, 2008 by Guest