>>
>>SET DELETED ON should be default setting in your application.
>
>Sergey,
>
>Thanks for your thoughts about this. Yes, SET DELETED ON is the default. There are places in the program where I want to recall deleted items, but, I am careful to reset it when I finish.
>
>This seems to be working OK now.

Hi Jim,

It's better to consider deleted records as none-exitent. I makes moving to other backends, like client-server, easier.