Hi,
My application uses a free table like HINAMES.DBF. My users can put their tables anywhere on their network. So I store the Path to the data in another table and get the path when the App starts:
mPath=MyTable.Path value="c:\data\"
Then, I set a variable to the whole path of the free table:
mDBFnames=mPath+"hinames.dbf"
Therefore, mDBFnames = "c:\data\hinames.dbf", and I open the table like this:
select 1
set excl off
use &mDBFnames
This code is in the Init event of my form, but wont open the table. I keep getting a:
Error - ControlSource - Record No 5. Alias 'HINAMES' not found.

I dont want these tables in the form's Data Environment because it stores the physical path of the table during development and I cant find any way around it.

Does anyone know any tricks for either the Init code or taking the path out of the Data Environment?
Thanks, John Morga