Hi,

>>
I have a form with two tables, both are using "5-Optimistic Table Buffering".

TableA has one-to-many relationship with TableB. When a record is changed in TableA, there are more than one Records affected in TableB.

When I want to issue Table Update, what should I do?

Currently I am using
TableUpdate(1,.f.,"tableA") and
TableUpdate(1,.f.,"tableB")

Is it correct?
>>

There is a danger that the update to tableA will succeed but the update to tableB will fail. Use a transaction to wrap the two updates:

BEGIN TRANSACTION
IF TABLEUPDATE(1,.f.,"tableA") .AND. TABLEUPDATE(1,.f.,"tableB")
  END TRANSACTION
ELSE
  ROLLBACK
  * Handle the failure
ENDIF    

>>
I have another problem where when after I issue TableRevert(.t.,"TableA") while on record number X, if I go to Record number Y and issue TableUpdate(1,.f.,"TableA"), the record number changes to X automatically.
>>

From TableUpdate Help:
If table buffering is used and multiple records are updated, TABLEUPDATE( ) moves the record pointer to the last record updated.

HTH,
Viv