A few more thoughts:

- when a user "copies" a quote, the current procedure puts the records to be added into a view and then posts the records as a batch

- in the past under older code, I instead added these records via doing a SCATTER from the source record and then an APPEND BLANK into the target table followed by a GATHER; I can't say this worked foolproof either

- in my mind, there should be no difference between a view posting new records and doing so via APPEND BLANK or INSERT INTO - lock the header, add in the rows, write in the data, unlock the header etc
---> is there a difference?

- there is no buffering on the target table...would it work better if there was? Again, I don't see how this would make a difference but am just looking for ideas?

Thanks all.

Albert