Jump to content

This topic is 1959 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

 

post-112258-0-79218900-1422538060_thumb.

post-112258-0-71157200-1422538430_thumb.

Link to post
Share on other sites

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?

Link to post
Share on other sites

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

Link to post
Share on other sites

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

Link to post
Share on other sites

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.

Link to post
Share on other sites

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. :yep:

Link to post
Share on other sites
  • 1 month later...

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..

Link to post
Share on other sites

This topic is 1959 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.