Hi,

 

I have the attached log in script that is running on my db to provide access to colleagues to certain records.

 

I've just been informed that one colleague can see more than they are allowed so I've had a look at the script using the debugger again.

 

When testing previous it worked fine, however, now that there are multiple users (via Pro app) on the system, it appears that it is not picking up the right accountname from the table but storing the accountname of the last person who logged in.

 

Is there a step I can add that will get it to clear out the last login information from the script once someone initiates the script.

 

It is possible that two or more people could initiate the scriipt at the same time.

Thanks
Ann

 

I don't quite follow.  You go to the layout but you always test against the first record (or whatever record you land on)?

 

Can you describe in words what you are thing to do with the script?

Hi Wim,

 

When the teacher logs in, I want to look up the account name they've logged in with in a Dept table to see if they are head of dept. If they are, then I want to give them access to only the records of the staff members in that depts. I find this in the staff table by using the DeptCode given to each staff member.

 

However, if they are a member of the SLT (not in the HoD table) they get access to all staff records.

 

Thanks

Ann

Hi Wim,

 

When the teacher logs in, I want to look up the account name they've logged in with in a Dept table to see if they are head of dept. If they are, then I want to give them access to only the records of the staff members in that depts. I find this in the staff table by using the DeptCode given to each staff member.

 

However, if they are a member of the SLT (not in the HoD table) they get access to all staff records.

 

Thanks

Ann

The part that I'm not getting is the second line of your script.  You do an IF to check the account name.  But no find.  So it will check against whatever record that layout happens to be on.  Not against all records if that is what you are expecting.

Thank you, I've performed a find on the layout and it works fine.

Sorry if my errors seem very numpty like. I'm trying to teach myself and still getting to grips with how filemaker works. I appreciate all the help and advice.

hi aguest, please i will love you to put me through on how you achieved your result.. Your case is very similar to mine.. Maybe your idea will really go a long way to assist me.. Here is what i want to achieve

Please, how can a staff be restricted to

his/her own staff page.. ie redirecting a

staff to his/her own page (staff layout)

once he/she logs in. The essense is to

limit staff view of other staff's pages

and hence activities..