Here is a problem I am sure has been solved many times over.

I have a local table A with a few hundred records that I want to join to a remote table B holding several million records. Running VFP 5.0

Problem 1: When I CREATE the remote view (programatically) as SELECT * FROM B, it goes away and seems to actually populate the view. At least the odometer says so. Millions and millions and way too much time. How do I stop this from happening ?

Problem 2: When I try to build the Local+Remote view using the View
Designer, it blows up. Is this common ?

Problem 3: Is there a strategy or syntax that I can use to optimize the Local+Remote view so that it does not pass all of the Remote View over to the Client side ? I currently use SELECT remoteview.* from
localview,remoteview where localview.a=remoteview.a

Thanks for any help.