Best way to display records for others

[Jbryancoop]

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 the teacher that shows their budget of what they can spend each month and how much they get for each class.  How can I send them a "dashboard" that has the records of their students, AND the one record for each teacher that has their budget?

Thanks,

Jeff

[TheTimeSavingCo]

What if we used a List view? We'd create one view per teacher, filtered to display the appropriate teacher's name

 

Link to base

[VentureOff]

The issue with that, is I need to be able to send this "view" to individual teachers such that they only see theirs and nobody else's.  Plus I need to link that other record from another table.  

[TheTimeSavingCo]

re: The issue with that, is I need to be able to send this "view" to individual teachers such that they only see theirs and nobody else's.

Yeah, we'd create one view per teacher, filtered to display the appropriate teacher's name and send that link?  Apologies, I feel like I'm missing something

---
re: Plus I need to link that other record from another table. 

Are you saying that, besides the "Teachers" and "Students" table, you have a "Budgets" table?  If so, you'd just link the appropriate budget record to the appropriate teacher record, then use a lookup for it, and then display that lookup in the list view