Forum Discussion
ArchiveUser
6 years agoQrew Captain
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!
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!