>I don't understand why you don't get full optimization here. Surely, you have both tables indexed on MasterID? What about DELETED() tag name: it's recommended to not call it 'DELETED' itself and use other name.

I didn't know about it. I'll explode the data later on and give it a try. Some times is called deleted and other times delrec. Thing is that it was working before.

Thanks.

Silvio