2. PHPRunner General questions
  3. How do I limit records based on login table field
This topic is locked

How do I limit records based on login table field

 		5/15/2008 11:56:17
PHPRunner General questions
L
 lozzer author

Hi
Sorry for being so NEW !!
If my login table contains
user

password

account No
and my orders table contained
order no

account no

part no

qty
How do I limit the displayed records from the order table to those with the same account no as the user logged in ?
In other words, the user can only view their own companies orders.
Thanks
loz
J
 		Jane 5/16/2008

Hi,
use User can see and edit their own records only security method on the Advanced security settings dialog on the Security tab for that.

Select account no field as OwnerID in both dropdowns.
B
 		bochaka 5/21/2008

i would like to try something similar, where the logged in user has the option of viewing all records(_generalrecords) in a specific table or just their own records from that table
J
 		Jane 5/22/2008

Hi,
you can create custom view of this table and set up different security methods for this view and for main table.

For example select User can see and edit their own records only method for custom view and User can see and edit all records method for main table.