I have two tables with a relation between them and I have set optimistic table buffering on. On my form, I have Grid1 for Table1 and Grid 2 for Table 2. As I scroll through Grid1, corresponding Grid2 is working perfectly. Grids are read only and to add or edit records in Grid2, I go to a class with corresponding objects that are bound to Table2. To add new records, I am appending a new record in the Table2, and this will force the bound objects to clear themselves out and ready for new fields. Editing and adding new records work perfectly, however, when I add new records to Grid2 and wish to delete one of the new added records, Grid2 will not refresh properly. The Grid2 record is marked as deleted, but still shows in the Grid. How Can I get the Grid2 to refresh correctly and not show the deleted record with out doing a tableupdate? Set Delete does not fix. I'm assuming the problem is the fact that the buffer still has this record and Set Delete is for the original table.

I have a work around by using a View, but project manager wants to eliminate the view and work directly with tables. I seem to remember similar problem discussed before, but can not remember or find solution.

Any help would be greatly appreciated.

Thanks in advance.