You need to have all the fields in the view which you want to see in the grid. Then as Al said use the view fields as your grid column ControlSource values. When you use the CustomerOrder table values in the grid columns the record pointer stays on that record of CustomerOrder even when you change the record pointer for vOrder.

HTH
Barbara

>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.