>Are these records in a child table? If so, make sure you are populating the foreign keys properly, and committing the parent record before attempting to commit the children.
>

---

Thanks! It is Item table which is the most lookup parent table(Not child)!

This situation sometimes occur even only one PC start the application! >.<'

I want to know if the Item table is reopened in more than one work area..
and all workarea are set to Buffer mode 5!

Will some of the work area fail to update?!

In Normal case, there are 3-6 users work at same time but each update success.
but sometime got above abnormal case! >.<'

I would take attention on foreign key ... and also Aerror() when fail update!

>>In Buffer Mode 5, the coding for Tableupdate():
>>
>>

>>IF TABLEUPDATE(.T.) == .F.
>>	WAIT WINDOW "Fail in Update Old Record" NOWAIT TIMEOUT 10
>>ELSE
>>	WAIT WINDOW "Success in Update Customer!!" NOWAIT TIMEOUT 10 ENDIF
>>

>>
>>But Not matter how many times user click Update Button, it still fail!!
>>
>>What can user do!?
>>
>>On the Contrary, if user use another function and reopen the same table again, it can update it at that area!!
>>whereas if return back to old work area, the data can't update!!
>>
>>I want to know why fail to update if both workarea are set Buffer mode 5!