>Thanks for your patience, your answers are helping. There are two scenarios that these views are used. One is where there is a batch upadate between the two databases(VFP & SQL) on the LAN where they are located. The other is where a user thru VFP app looks at the two databases thru a WAN. In the second instance is there any Rushmore advantage taking place thru indexing on the remote views?

Glad I can help < g >. The advantage of Rushmore does not happen until after you have pulled down the data from SQL Server. And in a WAN scenario, this is were you have to be careful. You want to make sure that the user is only pulling down the necessary data. Your application should not work like a normal VFP app, where the user can see all the data every time them bring up a form. The application should force the user to selective. In other words, rather than bringing up a form that displays all 10,000 customers in a grid, you want the user to select which customers they want to see. Maybe they want to see all customers in New Mexico, or all customers with an outstanding balance over $5,000, etc.

Also, I just started working with the Mere Mortal framework, which handles switching between local and remote views on the fly.