To your first question, yes. The issue is that my end users can see the Emergency Phone Number field when viewing the Aspen Students record, but cannot see it when viewing a related child record in the Student-Athletes table.
However, this is only the case for some child records on the Student-Athletes table. Users can see data in the Emergency Phone Number field for student-athletes that they have access to through the Schools --> Aspen Students --> Student-Athletes pathway. But they cannot see data in those fields for student-athletes that they have access to through the Schools --> Teams --> Students on Rosters --> Student-Athletes pathway. In either case, data in the Emergency Phone Number field is consistently visible/non-visible on all forms and reports.
To clarify a little, users are associated with specific records in the Schools table through a field called Assigned User. I'm trying to trace that field through the schema to the Student-Athletes table using lookups or summary fields as appropriate so I can use it to determine permissions on the Student-Athletes table. I believe I'm making an error in how I'm doing this since one pathway works and another does not.
And yes, as an administrator I can see data for all fields and all records in both tables.
Thank you for your help!
