Hi Terry,
Sorry, I should have made that clear in my original post.
SET DELETED ONIn 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
>>
Liam O'Hagan
MCP VFP Desktop Apps