>>select top 100 pkField from myTable ORDER BY PkField DESC ?
>>
>>Also ORDER BY is not guaranteed to be optimizable. It's VFP engine that decides if it wants to optimize it or not.
>
>I am changing my approach to this design. Thanks.
You're welcome.
If it's not broken, fix it until it is.
My Blog