2. PHPRunner General questions
  3. 'Users can see and edit their own data only'
This topic is locked

'Users can see and edit their own data only'

 		8/28/2007 10:37:26 AM
PHPRunner General questions
J
 JGarzilla author

Hi to all.
Good afternoon, from Spain: Congratulation for their PHPRUNNER

I am proving the version 4.0 before buying it, but I meet with a problem:
In a project I have a table: COMERCIALES related with another called PEDIDOS and the relationship is of one to several, and the primary key is idcomercial (COMMERCIALES ==>PEDIDOS)

on the other hand I have a table: GROUPS related with COMMERCIALES the relationship type is of one to several and the primary key is idgrupo (GRUPOS==>COMMERCIALES)
when a salesman (of the table COMERCIALES) begins a session, this salesman he can see and to edit the other salespersons' orders
In the step "Advanced security settings" has selected:
the table: "COMERCIALES".

selected the option: "Users can see and edit their own data only."

In "Users Table: OwnerID field" I have selected the field=idcomercial (primarykey of table COMERCIALES)

In "Main Table:OwnwerID field"= idcomercial (primarykey of table COMERCIALES)
I don't know that I am making bad.

I thank your help. Greetings
Alexey admin 8/29/2007

Hi,
I suppose your orders are stored in PEDIDOS table.

So proceed to the Security tab in PHPRunner, click Advanced, choose PEDIDOStable and select Users can see and edit their own data only mode.

Choose idcomercialin both OwnerID boxes.
J
 		JGarzilla author 8/30/2007

Hi,

I suppose your orders are stored in PEDIDOS table.

So proceed to the Security tab in PHPRunner, click Advanced, choose PEDIDOStable and select Users can see and edit their own data only mode.

Choose idcomercialin both OwnerID boxes.


resolved!!

Thank you for your information Alexix

Recibe un cordial saludo.