I believe what you want to use is user filters:
Hope this helps!
Thanks Tracy for you responce. What I'm looking is - visibility of records depending upon the employee level. if a individual contirbuting employee logins then He/She should see only his/her record but if a manager logins then He/She should see his/her own records as well as all remployee working under him/her. Also of employees working under any of the employee who are wokring for him. So a "n" level hirerchy exists. I know this can be resolved at DB level in Oracle & DB2 by using "connect using" clause in SQL query but what about others? I'm using Progress's Openedge DB.