Thanks so much for your suggestion. I did not know this syntax fo using tmp(). I'll give it a try.

I've just tried something that did solve the problem. I've set KeyLinks = TCCLIENTS.CLIENT and KeyLinksAutoDefine = false. It seems to have solved the problem. It was very odd, that data would be lost when the where clause was modified..

I will, though, try your solution too!