>>>>Use SET DELETE ON setting so you wouldn't need NOT DELETED() in your select. Anyway you cannot use NOT DELETED() in multi-table select because it may produce incorrect or unexpected results.
>>>
>>>Thanks Sergey. Another lesson learned:)
>>
>>Keep in mind that SET DELETE ON is scoped to the datasession.
>
>IOW, it has to be reset each time it is need in the IntereactiveChange? Or can I simply place Set Deleted On in the Init event of the form itself?
Put it in the Load event of the form. IF you had any controls bound to a table that had deleted records, the Init is too late to prevent that.