>>>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...
If it's not broken, fix it until it is.
My Blog