>>You code looks simple enough. Are there any filters on the OrderItems table?
>>
>
> NO
>
>>Can you pause the program where I inserted a comment and browse for Order_id = lcOrderNum?
>
>I set variables in a watch window of a debug session. Sometimes it matches, sometimes it is 0. I think the c_orders cursor is in a one-to-many relation. If I browse that cursor, I see the extra records with *s.
>
>>Have you confirmed directly after this line that the values are not being written, or could htis be a buffering issue?
>
>The thought has crossed my mind. The base form has buffering set to optimistic. It has a button for Reports, which sets a local variable and passes it to the .prg containing this code. Since the table not being updated has child records, it should be handled as Optimistic Table Buffering, I believe. Wouldn't the ENDSCAN commit the changes as it selects away from the table?
>

Nope. Selecting a work area does nothing to commit changes. with Table buffering, the only way to commit is with a TABLEUPDATE().