Thanks! 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. Again, thanks.

Doug