Looking for better user view control

You can add code to the "Before SQL Query" event on all the appropriate pages (List, View, Edit, Export, etc):
Example:

$strWhereClause = whereAdd($strWhereClause , "(Table.useriid = '" . $_SESSION["useriid"] . "' ");
This assumes you have the user's internal ID or user id value in each table (which you should) and at the Login Page event "After successful login" you also store such value in a session variable such as "useriid" above.
Example:

$_SESSION["useriid"] = $data["useriid"]; (where useriid is the internal ID or user id value from your user-login table)
Does this make sense?

Hi Chuck,
That makes sense, I have just switched off the Advanced Security option for "Users can only view and edit their own data" and the Admin can add new users without that silly error.
There is a little issue with the formatting of the example you gave, it creates a PHP error <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=63212&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
Event Code: $strWhereClause = whereAdd($strWhereClause , "(UserData.UserName = '" . $_SESSION["useriid"] . "' ");
Error Message: select count(*) FROM UserData where (UserData.UserName = ''

Hi Again,
Just fixed the code and it works <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=63213&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Only little issue now is that the admin can only see his/her record as well... hmmmm
Code: $strWhereClause = whereAdd($strWhereClause,"UserData.UserName ='".$_SESSION["UserID"]."'");

I found a fix, its not perfect but I will work on it.
Code :
if ($_SESSION["UserID"]<>"AdminsLoginID")

$strWhereClause = whereAdd($strWhereClause,"UserData.UserName ='".$_SESSION["UserID"]."'");

Chrys,
You can make the expression as complex as you would like. Example:
$strWhereClause = whereAdd($strWhereClause,"UserData.UserName ='".$_SESSION["UserID"]."'

OR '" . $_SESSION["eugroup"] . "' = 'admin' ");
In this example, column eugroup is the group from your user login table. In the After Login Successful event, also put that into a session variable. I think I have the syntax correct in this. Just make sure you use the "whereAdd". I have forgotten and directly modified the Where string, and that will give you unsatisfactory results most of the time.
If you upload and test, just don't forget to log out of your app, then log back in, so the session variables get set from within the After Login Successful event. :-) I can't tell you how many times I have not done so when using something from that event, then kicked myself when I finally realized my mistake.
Chuck