By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Combobox - list only remaining values available to group

P: n/a
Suppose ClassStudents has Class, Student, ... and a student is to be
replaced by a different one in a different Class.

If the student is shown in a combobox, how would the row source be
specified to only list students that are not already in the class?

select Student
from AllStudents
where Student not in
( select Student
from ClassStudents
where Class=<... Class of current row ...>

The ...class of current row... being the tricky part.

Feb 12 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.