>I am interfacing with a third party VFP app and am having the devil of a time figuring out the cause of a sporadic error. The error I receive is "record in use by another" eventhough I am the only one logged in (100% sure of that). The error comes from a REPLACE statement that updates the grandchild table after the tables have been updated and the transaction is closed. As I said, I am the only one in the system, no other datasessions using the tables are open.
>

If i understand correctly,
you have a 3 table relationship setup
you start a transaction
you end the transaction
you then try to do an additional REPLACE

Have you tried closing the other 2 tables when you finish the transaction or turning off the relationships ?