How to cross reference tables?


#1

Sorry for the weird title.

So I have a table of tutors and a table of students. In the tutors table I have criteria such as subject expertise, pay wanted and grade levels the tutor can teach. Similarly, in the students table I have criteria such as subject needed help with, amount paying and grade level. I want to be able to match tutors to students based on shared info.

It may be easier to look at both tables

For instance, Aaron is a tutor in Business and Math. He wants 11-15$/hr and cant teach 6-8 grade as well as k-5th grade. I would want to be able to see all possible students that match those criteria. One such student is Gabe who wants to learn math, is willing to pay 11-15$ and is in 6th-8th grade.

I would like to be able to see all possible students for each tutor.

Is this even possible? (it seems like I want a way to filter one table based on a record from the other table).

Thanks so much!
-Arjun