I have a Local view which only contain the key field of the table, eg

Source table : customerOrder

field :

ID
CUSID
AMT
ITEMID
DESC
QTY
UNITPRICE
personInCharge

and The View select only the record that the user are allow to see

CREAT SQL VIEW vOrder AS;
SELE id ;
FROM customerOrder ;
WHERE personInCharge=?mPer

I only the the id field rather than select all fields becouse it will faster the data transfer from the network.

In my grid, the recordSource = 'vOrder', and at column level, I put controlSource = customerOrder.cusid, customerOrder.amt and so on.

But it is not work when grid is scroll into next page. Why??

Any suggestion??

Thanks.