Thanks for your help.
>Hi Caroline,
>
>Because there's nothing to optimize. VFP has to scan(read) whole table in this case.
>
>>Many thanks to you both for clearing that up for me.
>>
>>As an aside why does a view with no filtering and just 1 table come back with no optimisation?
>>
Caroline