Conflict of intrest (1 Viewer)

[dennisbowman]

I need a form that has One comboboxe and a listbox. The Comobox holds a list of students and a list box that only displays only the teacher that havent taught the student.
for example if i have 4 employee one name don, and don had a lesson with a student,when that student is selected all the employees are listed in the listbox except don.

Thanks in advance
Dennis

 

[theDBguy]

You can either use the Not In() or Not Exist in your WHERE clause.

 

[arnelgp]

for the listbox,
you can first create a query that will list all possible Student + Teacher combination (see qryCrossJoinTeachersStudents query).
then create a query that will list teachers not already taught the student (qryLstSource, this is the row source of the listbox).
see Form1.