So,

Have you tried set table buffering (e.g. 5)? It may solve this problem...

>Dear all,
>
>I face a serious problem.
>
>I implement an applicaiton in which a table 'stockitem' host the stock information.
>
>The buffermodeoverrid set to 3
>The stockcode field set to the candidate key
>
>I implement a ADD button inwhich I APPEND BLANK
>With SAVE button, I confirm the adding by tableupdate()
>and UNDO button, code tablerevert()
>
>However,whatever I change the parameters, I got a new record with NULL stockcode after I press ADD, then UNDO it.
>
>What wrong I have been made???
>
>
>With regards
>
>Ransome