>Could someone please explain to me what the proper way is of using Buffering and Tableupdate() ?? I'm trying to do something that is fairly simple in a mutiuser situation. I have 2 forms, a main form displaying several tables using a page frame with grids for each table. One of the pages and it's associated grid will contain records that will be added to the other tables (grids and page frames) once authorization has taken place. Currently the tables have no buffering and are relying on the main form's optomistic buffering scheme. The second form simply allows one to add or edit a record on the one of the tables in the main form ... The second form has optomistic row buffering enabled on the chosen table from the main form. Before calling the second form I scatter memvar (or blank) depending on what action the user has requested .(edit or add) This seems to work OK until I want to update the main form. If I do an INSERT INTO (SQL) and then a TABLEUPDATE() the main form and the grid are
>refreshed properly. BUT if I do a GATHER MEMVAR and then a TABLEUPDATE() (as in I only want to edit a certain record from the main form) the grid is updated but the WRONG record is updated ?? What gives ?? Do I have to pass the record # to the second form ?? Can scatter and gather NOT be used with buffering ?? Do I have to go back to the old way of rlock() and lose the advantages of buffering ?? How do ensure that other users will see the updates without having to page up and down in the grids ??

I suggest that you forget about Scatter & Gather commands.
I use Optimistic row buffering for header file and Optimistic table buffering for detail file.

If I want to update multiple files at once I use begin transaction command, because you have the facility to rollback all the updates once an error occurs.