>>I am using a view in a form: v_test
>>The view is a local view in a dbc called: test
>>The table is called test.dbf and is in a folder called c:\test\01
>>
>>So the SQL for the view is:
>> SELECT * FROM test!test
>>
>>I want to be able to use the same view against the same table located in folder c:\test\02. In other words, multiple sets of data.
>>
>>The cursorsource of the DE is v_test.
>>
>>How do I change the table location in the DBC to be:
>> c:\test\02 instead of c:\test\01
>>
>>Any ideas?
>
>AFAIK, you cannot do this using the same view. You probably want to create a second view pointing at the second set of data...
>
>but perhaps I could use a little more background on why you are trying to do this...


Erik:

It is an accounting system.
Each folder would be the books for a different company.
I want to use remote views for the connection to SQL Server.
I want to use local views for Fox.
I want to be able to use the same forms for connecting to both SQL and Fox.

The database tables would be identical in Fox, just stored in different folders.