Naomi,
>
>Sorry it has taken me so long to get back to you. I got pulled off on something else.
>
>I used your suggestion about putting a breakpoint in the __RI_DELETE_projvisits code, the code called when I want to delete a record in the parent table (ProjVisits). As I step through the code, I can see that it works fine the first time that I try to delete a record in the parent table. The SEEK command in the RI DELETE code finds a record in the child table, and prevents the deletion. If I make a 2nd attempt to delete a record in that parent table, a very odd thing happens. When the __RI_DELETE code opens the child table before performing the SEEK command it open a table of the same name in a different database of the same name in another folder as the database I am testing. I have not yet been able to figure out how this is happening. When the __RI_DELETE code opens the parent table I can see that it has the correct path. Can't see where it is changing the path.
>
>I'll report back again when I've made some progress on this.
>
>Jim
Weird :( Do you need both databases in your project? Can you temporarily move the second database somewhere not in VFP Path?
If it's not broken, fix it until it is.
My Blog