Jump to content
Sign in to follow this  
smith

restricting users to "find" only their records

Recommended Posts

Have a small report card database - students file and report card files. I have kindergarten teachers directed to a specific report card layout based on their log in. They enter in Find mode and select their teacher name from a drop-down menu and "find" their students. How do I restrict that so the kindergarten teachers can only find their students and the primary teachers can only find their students. There are four kindergarten teachers logging in and 10 primary teachers into a database of 400 students. I don't want them to have access to all 400 students, only their own. Any help anyone can give, I'd appreciate it. I am new to FileMaker; and using 6.0.

Share this post


Link to post
Share on other sites

The real way you do this sort of thing is to take control of the interface and lock the user out performing operations manually using FM's menus. When we develop a solution for client, menus are turned off and the status bar is hidden and locked. All operations, including navigation, are performed by scripts we write connected to buttons the user clicks.

If a find is performed by clicking a button the triggers a script, you can add whatever additional criteria you wish (such as UserID) to the find operation. An even better way to do this is to use a "go to related record) script step to show only the current user's records and then use a find with constrains the found set to narrow the search further. Done correctly, the user won't know that students beyond theirs are even in the file.

-bd

Share this post


Link to post
Share on other sites

Two basic ways of doing this:

- the fully scripted way where you don't let the users in find mode at all but your scripts do the find for them. That gives you extra control over what records to display

- using 'record level access', where a calculation in the access privileges lets the user only see the record they should.

Share this post


Link to post
Share on other sites

It would be easier to do this in 7 but basically what you have to do is create a login screen where people login using a global field. Once you have their name in the global field you just script all searches to include the global name as part of the search. Using the Get account name function in 7 makes this much easier though. good luck

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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