>>>>>>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:
>

ok that doesnt make me point...but if i close the report and run it again it tells 
>select client.*,acc.status;  &&acc is the remote table
>from C:\Work\acc ACC;
>inner join mainbase!client Client on acc.clientid =client.clientid
>

ok that doesnt make me point...but if i close the report and run it again it tells
>select client.*,acc.status; &&acc is the remote table
>from C:\Work\acc ACC;
>inner join mainbase!client Client on acc.clientid =client.clientid
>
mwhahaaa that works thanks u >all as well :)