Hi
I have a 3 tier system, staff, pupils and reports.
Each member of staff has many pupils in his/her tutor group. Each pupil has one report
staff have a Group field, which has data like `7P` in it, denoting the tutorial group they manage.
I have a field in each pupil record that contains the same data, so I can use "Users can see and edit their own data only".
This is fine, teacher logs in can only see his/her tutorial group members.
Lovely, just what I want.
Now the heads of year and Assistant Heads and Deputy Head and Head Teacher want to be able to see all pupil records, and edit them if need be.
These additional users are in the same table as the teachers, but the Group field has data in like HOY for Head of Year, ASS for Assistant head..... you get the drift.
So when one of them logs in, they cannot see any pupils because they do not have the correct link from the Group field to the relevant field in the pupil's record.
Please give me an idea how to work round this, or even how to re-structure the data to avoid this error.
Thank you