finding records that have related records matching two (or more) criteria in a portal
I've got a STUDENTS table (with individual student data) and an ENROLLMENTS table (that joins students to classes in a CLASSES table).
With a portal showing enrollment data in a STUDENTS layout, I understand that I can find, using two simultaneous requests, all students who are in class A or B, but I can't figure out how to do a find for all students who are in both class A and B.
I've seen a few other similar questions (some with answers), but I don't think I've yet found the answer to my specific question. Thanks in advance for your help or for your help in directing me to the correct thread!