Thanks for the reply. The primary key-value "1234" is just an example. It's actually a compound key with sod_no+sod_ln. So with 3 records, it will be "1234"+"01", "1234"+"02", "1234"+"03".

Sorry for the poor explanation, hope you understand now. I'll try to be very precise the first time in next posting. Also, this problem only occur once in a while, which makes debugging a bit very difficult.