Thanks for the quick 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. Also, this problem only occur once in a while, which makes debugging very difficult.

>If user A added 3 records why key has only one value '1234'?
>Mark