Problem in Matrix Form

deepthi.v

Hai Experts,

Iam using form ,in that form iam having One matrix form the source table of main form is item and the source table for matrix form is customer .
i wnt to filter the responsibilty center field.
when iam filtering the matrix form with Responsibility centers the cursor in the matrix form is going to the last rec.

eg: resp.center 20100 is having 12 rec 20101,20102......20112
20200 is having 12 rec 20201,20202,......20212
if i filter in ascending order the cusor is in the first position i.e when we first filter 20100 and then 20200 the cursor is in the first rec i.e 20101and then the cursor is comming to 20201, but when we first filter 20200 and then 20100 then the cusuor is in the last position i.e it shows the rec position in 20112 .

how can we get the cusor to the first rec i.e 20101 when we filter in descending order also.

deepthi.v

We have to write the code on OnInputChange trigger of Responsibilty Center field.

Code:
Clear(Currform.CustomerMatrix.MatrixRec);