>>Naomi,
>>
>>I am not explicilty using the SET PATH command in my application.
>>
>>What is particularly odd is that the RI code comes up with the correct path to the child table the first time I try to delete something from the parent table, but the wrong path to the child table the 2nd time I try to delete something from the parent table. If the search path is the issue, seems like the search path is changing while the program is running.
>>
>>How can I find out what the search path is from a running program?
>>
>>Thanks,
>>Jim
>
>To find the path
>
>=messagebox(set('path'))
>
>also it could be that the default directory changed by some reason?
Naomi,

I put MessageBox(set('path')) and MessageBox(sys(2003)) in the RI_Delete code just before it call DBF(lcChildWkArea) that gets the full path to the child table, and then after it gets the full path to the child table, I use MessageBox(pcChildDBF) to display it. pcChildDBF has the wrong path, but neither the search path nor the current directory contains that wrong path.

Very strange.

I appreciate your suggestions.

Of course, I can just rename the folder that it is using to get the wrong path, and the problem goes away. But, I sure would like to know why this is happening.

Jim