find and sort based on groupname

[mallikai]

i have a timesheet database for employees...

I would like the employees to only have access to their own records and also for filemaker to only list their records and sort based on date.

There are 9 employees and i have assigned each to a group and have made the appropriate passwords for them...

however, i have not been able to figure out how to create a script that will find and sort based on their groupname? It is my impression that the find command performs the last find you did and you cannot set it to perform 9 different searches in one script?

for instance...if i have an employee field...

i would like to say...

groupname is Robert and Employee field is RM then find and sort based RM

groupname is Adam and Employee field is AW then find and sort based on AW

groupname is Gary and Employee field is GB then find and sort based on GB

etc.

any help would be appreciated...

thanks