2. PHPRunner General questions
  3. How to allow users to see specified records?
This topic is locked

How to allow users to see specified records?

 		5/3/2007 3:47:40 PM
PHPRunner General questions
R
 robtastik author

I have setup a table that has 1 admin and multiple users. admin has all privillages and is the only user that will be adding records. the other users will only be able to list, view and search records. Since none of the users will be adding records how to I make it so they will only be able to see certain records when they log in? ex: when userA logs in I want them to only see records for clientA.
R
 		rcurtin 5/3/2007

I am still new at this but I think I can help you. Basically I think you need to create a feild specifying clientA data. Then in the Group Permissions setup you assign that field to cross reference the userID field for the table you wish to designate.
So if you only wanted a user to see for instance client = Microsoft then you set a feild in which you put the value Microsoft, then in user permissions (step 7 advanced) pick the table = table1, then you pick the option that users can only see/edit their own data, then you use the drop downs to specify the userID and the client field.
again keep in mind I am still very new at this but I beleive that will do what you need it to
R
 		robtastik author 5/3/2007

Thanks alot I will give this a try and see how it works