>>>>Followup...
>>>>
>>>>I just renamed the folder containing the copy of the database that I am testing. Now, __RI_DELETE_projvisits correctly finds both the parent and child tables, sees the conflict and prevents the delete.
>>>>
>>>>Any thoughts on why it looked elsewhere for the child table?
>>>>
>>>>Thanks
>>>>Jim
>>>
>>>It may be a bug in RI's code - with USE command it opens the first table in finds and the other database happens to be first in the search path (this is what I suspect may be happening).
>>
>>Which VFP search path are you referring to? I'm runn VFP9. Tools...Options..File Locations doesn't list that folder at all.
>>
>>Again, any ideas would be appreciated.
>>
>>Thanks,
>>Jim
>
>In your application what is set by SET PATH ? Perhaps the folder with the other database is the first listed in the set path...
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