Hi Winn,
That filter on DELETED() is probably what's causing the problem. You shouldn't use DELETED() with multi table queries. Instead, you should use SET DELETED ON.
Regards,
Liam
>Jorge,
>I have found that by having the tables involved opened did the trick. You were right, I should have debugged it more throughly.
>Thanks,
>Winn Pauley
>
>>Have you tried debugging it?, step through it, and check the resulting where expression. What about the lcMajor, variable?, when is a value assigned to it?, have you checked that it has the expected value before executing the query?.
>>
Liam O'Hagan
MCP VFP Desktop Apps