Mike,

No I mean a real INDEX ON to order the data so that when you do your INSERT - SQL you record will appear at the proper place, ie the bottom of the grid.

Say you had a cLineNumber in you view. You would index on cLineNumber and do an INSERT (cLineNumber) VALUES (cNextLineNumber) INTO CURSOR cCursor the record would be at the bottom of the grid.

HTH

Rex
>Rex:
>Do you mean to use "Order by" in the view? We considered this, but we plan to use the views in many places, where the "Order by" might need to be different.
>
>Mike