Hi Terry,

Sorry, I should have made that clear in my original post. SET DELETED ON

In a single table query you can use deleted() if you don't specify an alias or work area, but in a multi-table query you have no way of knowing in what work area or with what aliases VFP is opening the tables on which to perform the query.


Regards,

Liam


>Interesting. How would you eliminate deleted records in the source tables from showing in the final output then?
>
>Terry
>>Hi Terry,
>>
>>A point unrelated to your question - be careful with the use of Deleted() on multi-table queries. You may get unexpected results.
>>
>>Regards,
>>
>>Liam
>>