We have a report where we need to provide section access based on Teacher name:
Eg: If Class teacher (Ann) handles 2 students, I only want those students marks to be view-able for him/her.
Please find example table below:
Ann should see only marks of A1 and A2.
Sue should see marks of B1.
Mary should see marks of B2.
This being said, I don't want to set it this way for all class teachers. The Principal (Jack) will have to view all students’ data.
Jack should see marks of all students in the school (A1,A2,B1,B2 and the rest)
Using * logic is not possible, as I will have to have all students’ name in the section access file to achieve this. The number of students maybe around 200 and having that many entry isn’t optimal. Also, the number of students will keep increasing. Please let me know if there is any work around for achieving this.
- Section Access, when applied with reduction, need to set all users access. If you don´t select this users from a file or database, this teachers will not be linked in a correct students;
- The option "*" you don´t need if you want to set "all users". You can use just a blank field.
- When we use a environment when users on section access made changes and need permit, we create a simple/routine code with separate situations: the defined users and the other with * ou blank field. In you case, you can select from database this informations and create this code to format you table.