Well, to get it to process remotely, the remote server has to have the data. The only way to get the data there is to pass it (usually via a string like XML) or let the server go fetch it. Splitting data that relies on each other across servers is generally a bad idea, IMO. And this is a perfect example of why.

Sorry I couldn't be of more assistance,
Chad

>We had some of that before. I wanted to implemented a full remote process now. I still have this 100mbps link between the two servers. So, most of the processes have been converted to remote process. But, the final INNER JOIN is still regular VFP SQL as we haven't found a reliable way so far to achieve that. So, it's working but I need to find something in order to improve the performance.