>Hi Scott ---
>
>You don't want to change a view from local to remote. What you want to do is make all of your controls bound to a local view which has a source of either another local view or a remote view. Put in a "translation layer" for the data, basically.
>
>
>>Is it possible to change the CursorSource at run-time from a local view to a remote view. Both views have to same structure expect one is from VFP and the other SQL Server. To the app the to cursors function the same. If I could change the source based on a indicator I could run the same application in for local data as I do remote.
>>
>>Thanks in advance
>>
>>
>>Scott k
Hi John

The controls on the form are bound to the cursor alias regardless of what data the cursor is bound to. I think were talking abou the same thing. The problem is changing the DataEnviroment.cursor1.CursorSource = "LVclient" (local View of client) to be something like DataEnviroment.cursor1.CursorSource = "RVclient" (remote view of client) at run-time. Cursor1 would be given the same alias "client" regardless of the source. All controls would be bound to client.fname, client.sname etc.

Thanks


Scott