>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.
Your column .ControlSources should be vOrder.cUsID etc. If you are not seeing data on grid load, set the value of mPer and issue REQUERY() on the view in the grid's .Init().
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up