2. ASPRunnerPro General questions
  3. Filter list page on login
This topic is locked

Filter list page on login

 		5/26/2009 09:37:19
ASPRunnerPro General questions
T
 telemark author

I would like to filter the list page dependant on which user logs in.
Each user has a department linked to them in a user table (DeptID). That same field is also in the list page, when the user logs in to the database only those records that have the same department as the user would be initially shown.
Currently the users filter the list page using the search facility every time they log in, so I would like to automate this step.
Could some one point me in the right direction.
Many Thanks
Andy
ASPRunnerPro 6.1 Build 1977
J
 		Jane 5/27/2009

Andy,
I recommend you to have a look at the User can see and edit their own records only security method on the Advanced security settings dialog on the Security tab. Use DeptID field as OwnerID.
T
 		telemark author 5/27/2009

Thanks Jane that worked perfect.
Andy