What is the value of SET REPROCESS? If it is set to AUTOMATIC, -2, -1 or 0 (with no ON ERROR active), VFP will loop forever. You might want to set it to a positive value. Don't forget that this setting is scoped to the current datasession and it is set to 0 by default.

HTH

---

>I have put code in for the transaction, but I noticed that if another user is editing a record in the child when the UPDATE command is issued, it continues to try to "attempt to lock" until the first user gets done with the record. I assume it will try all day if the first user "sits" on the record. Is there a way to have the UPDATE statement "time out" if it can't get the lock within a couple of seconds.