thanks jason i will give this a go.
you are right how the site will work, there is 2 users groups.
Admin and PowerUsers
Admin can see all the clients and PowerUsers only their own.
Is the above the best way to do it or leave the clients_Results.php as is for Admins and then create a further page called clients_Results_Users.php for PowerUsers and follow your guide lines?
I though i could maybe add in an AND in the Recordset created by Data Assist and set it to ClientUserID = Session(UserID) ??
Would that work?