>>>>>Hello all!
>>>>>i created a view that used a table in some far away folder totally for something else. it works but for every time i open the form that uses it. I have to point to it. Im gonna try a remote view but when i make it it says ...Connectivity error:{microsoft][ODBC Driver Manager] Data source name not found and no default driver specifited
>>>>
>>>>What is the type of remote table?
>>>>Is it VFP Table or you use some other DB?
>>>>If it is VFP table you don't have to use RV, You could use Local View and use full path to that table.
>>>
>>>
>>>reallyyyy where do i specify the full path...it is a VFP table
>>
>>I your View definition:
>>

>>lcFullPathAndTableName = "c:\TestMe\Test"
>>
>>CREATE VIEW AS;
>>SELECT ....... FROM (lcFullPathAndTableName);
>>WHERE.....
>>

>
>u mean that is in the "view SQL" of the view?

Try:

select client.*,acc.status;  &&acc is the remote table
from C:\Work\acc ACC;
inner join mainbase!client Client on acc.clientid =client.clientid