>>>Bottom line, I was just making sure I had not overlooked some obvious error in my syntax. However, I still see no reason why this should not work. I am going to try a more creative way later tonight.
>>
>>Let me know if you figurew out a way to do it. I blew most of an afternoon trying to get it to work...
>
>This was working on some of your stuff, and not my question, right? I will post results of what I try. I hate work-arounds.
The only way I know that this works dependably, is with SET DELETE OFF, to still get only not deleted records from a single table with WHERE DELETED() = .F.. Any time there was more than one table involved, who knows what you'll get.
Erik Moore
Clientelligence