Newbies jr_citizen Posted November 2, 2007 Newbies Share Posted November 2, 2007 I need to create permissions based on the following scenario, but can't figure out how to do so. I'm new to permissions in FMP, so it would be very helpful if you can detail how I may accomplish the following: If a user is in the LA group, then they can see all records, but only modify records where the "Office Location" field is set to LA. If a user is in the NY group, then they can see all records, but only modify records where the "Office Location" field is set to NY. If a user is in the Admin group, then they can see and modify all records. I've looked through the forums, but haven't found a situation that seemed to matched this. Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted November 2, 2007 Share Posted November 2, 2007 Do a search on Record Level Access, which is what this process is called. Basically what you need are 2 Privilege Sets, office and managers. Office has the RLA set to test for the location, and manager does not. Steven Link to comment Share on other sites More sharing options...
Newbies jr_citizen Posted November 5, 2007 Author Newbies Share Posted November 5, 2007 Steven -- Many thanks for your reply. I had looked through the forum and seen much discussion about this, but am still struggling with actually making RLA work. I've attached a copy of my DB with the custom privileges set. The two users I'm playing with at the moment are "lauser" and "admin" -- admin has full access, where the "lauser" should only be able to modify records where he is both in the "LA-Users" privilege set, and the "Office Connected To" field is set to "Los Angeles". This is just a play database so I don't mind sharing the details of it. The usernames/passwords are admin/admin and lauser/lauser. There is also a jhbuser as another test. Any help/guidance on accomplishing what I'm after is greatly appreciated! fntest.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6145 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 accountSign in
Already have an account? Sign in here.
Sign In Now