I have a database of students in various "home rooms" each assigned a teacher. I can easily create a view that shows the students in that homeroom that I can send to the teachers, however, there is one more record in another table that is linked to ...