Granting Access to a Parent Table Through Two Different Lineages

Problem: I have a database that manages team rosters for a school district?s athletics program. Users are able to view students attending their schools and also teams associated with their schools. ...