>This won't work as additional line of codes are being process and we need to lock the entire set of commands to make sure that one doesn't go in as long as a series of command is not completed. See my other reply I just made.

Michel,

I would do as I think someone else is suggesting. Create a Candidate index on the fields involved. And instead of locating the record first, simply try to insert the record. Catch the error (if one occurs). If you catch an error, you know a record already exists. Then, you can locate it and update it if necessary.