how to show user data based on its branch location only

You can use Advanced Security option 'Users can see all data, can edit their own data only' for this purpose.

other scenario to achieve this :

1. Make a new table in your database, for example BRANCHES_DATA with the following fields : branch_code (char 20, primary key), branch_location (char 30,)
   
2. In your user table (which contains username, password,....etc), add a new field : branch_code(char 20). Based on data IN BRANCHES_DATAtable, you can assign any branch_code for each user
   
3. In PHPRUNNER events : Login page > After Successful login, add the following code : $_SESSION["CUSTOM_BRANCH"] = $data["branch_code"];

   
   

   
   
4. Now you can filter list pages, lookup filter, etc...... using CUSTOM_BRANCH session variable.
   For example to filter list page, In PHPrunner events : Table_Name > List Page > List Page : Before SQL Query add the foolowing code to filter data based on branch_code
   

Thank you very much [b]Rthis solution is more like it.
[color="#008000"]One more question if i am not rude please.
[color="#008000"]But i have also got admin/manager users who can VIEW/ADD/EDIT/DELETE all/any branch data, how to set up such security levels?
" for privileged users only.

Check this:

http://www.asprunner.com/forums/topic/21656-dynamic-query-depending-on-user-groupid/

to make sure admin can see all records, use the following code in Table_Name > List Page > List Page : Before SQL Query

Note: in this example i assign username admin to a branch called "admin" in user table

Thanks Brother you are charming.I will use your advice.