This topic is locked

User can see and edit their own data only

11/23/2007 2:42:47 PM
PHPRunner General questions
R
Rigmantas author

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6897&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' /> Hello,

I have two tables:

product

sort

In sort table I use permission setings "User can see and edit their own data only". This work in list, add and edit pages from this table. But when in product table one fields I made lookup to fields from restrikted sort table, in add product page in drop down field, whish linked to restrikted page users can see others users values. And if user insert new values from this drp down field, he can't se these values in sort table list page. Can You help me. Sorry for my English.

Thanks

Rimantas

Alexey admin 11/26/2007

Hi,
PHPRunner doesn't apply security options to Lookup tables.

However you can implement this manually using WHERE expression in the Lookup wizard settings dialog.

The current OwnerID is saved in $_SESSION["OwnerID"] variable.
You can publish your project on Demo account( last tab in PHPRunner) and send a link to it along with the problem description to support@xlinesoft.com

I'll help you to build proper WHERE expression.