>Ron,
>
>It sounds like you have a unique index on the ord_id field in order_item. If I understand what you're trying to do, this is not something you want. I assume orders can have multiple items which means that the ord_id field in order_item will not be unique.
>
>Also, are you getting the primary key from the order table and putting it in order_item before you send your update?
>
>

Dear Josh,
I have checked whether there is any unique index on order_item.ord_id, and the result is no. (It sounds a little stupid that we here keeping trying check.:-)) And afterward, we decide to change the field name ord_id in order_item to another one, seeing whether the same problem would occur. In fact, just after change, the same problem occur, however, after re-structuring the order_item table, this problem seems gone. I am wondering whether it is possible that there is remained information about the unique index that might be done before. However, this is still open to observation.