Logic Required on At new.

Hi,

I have one database table with 100 fields. And, i am fetching the field values based on selection screen.

 Field1   Field2......FIELD9 Field10 Field11........Field99 Field100.
AB       12            AS       1000    S1           10 AM  11/14/2008
BC       13            BS       1000    S2            9 AM   11/14/2008
BC       14            RH       1000    S3            8 Am   11/10/2008

AB       12            BS       1001    S1            8 Am   11/14/2008
BC       13            AS       1001    S2            7 Am   11/14/2008
BC       14            RH       1001    S3            6 Am   11/10/2008

AB       12            RH       1002    S1            9 Am   11/14/2008
BC       13            AS       1002    S2            8 Am   11/14/2008
BC       14            BS       1002    S3            7 Am   11/10/2008

I have sorted the above internal table based on Field9,date and time. What i want is when ever the New field9 value trigger i have to take this record and can check the field2 of the perticular record.

if the field2 of the perticalr record is AS or RH.

Then i have to fetch that Record otherwise i have to ignore that record.

That is i want output like this.

 Field1   Field2......FIELD9 Field10 Field11........Field99 Field100.
AB       12            AS       1000    S1           10 AM  11/14/2008
AB       12            RH       1002    S1            9 Am   11/14/2008

Could you please help me in this regard?