You're welcome.
>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?
>>>
--sb--