This topic is locked
[SOLVED]

 Login Display Help Please

8/18/2010 15:39:18
PHPRunner General questions
R
Ricky001 author

Hi All
I am new to PHPRunner and have come accross an issue which I hope some one can please help me with
I have Two tables as listed below
Clients Table

ClientID - Autonumber

ClientName - Text

ClientPassword - Text

ClientLevel - Text - ( Admin , User )
My second table is as follows
ReportID - Autonumber

ClientName - This is added from Clients table in the form of a drop down menu

ClientReport This is a file with is uploaded
Everything works fine until i wish to yes login and clients can only list there own files
I have sent the advance tab in login to user ClientName and this works great
and set groups for User and Admin from Client Table which also works
My issue is when i sent lets say Client MR Brown to admin and only give admin the rights to add and edit records when i slect a client name from the drop down menu it defaults back to who is loged in and not the name from the list
if any one can help please write back

Sergey Kornilov admin 8/18/2010

This behavior is by design. When Advanced security mode 'Users can see and edit data only is turned on' new records are automatically assigned to the current logged user.
If you want to allow admin modify record ownership - create a separate Custom View on the top of this table and provide admin-only access to this view via User Group Permissions. Do not turn on Advanced security mode on this view to allow admin change ownership.

R
Ricky001 author 8/19/2010

Many Thanks for your help that sorted that out.