>Well, another pretty bad problem.
>I have form with many tables, where two of them have buffering set ot 3.
>When user clicks to add new record I append new record to each of those tables ( select table and append blank ). Then user changes his mind and click cancel. (I took most part of this mechanism from tasmanian traders app) In query unload event tthe record is checked if it's new and empty, or something has changed. If so user is asked what to do. If he choses to discard everything, I issue =TABLEREVERT(.T.) and then everything seems fien. But those two tables are related and changes in ( appending of new record ) is not discarded. And when I tracedit I found that even I have selected first table, getfldstate of second table is cleared after issuing tablerevert on first one.
>What is this?
> any ideas?
>tia
> Dezider

Dezider, are the two tables related in the DBC? If so, check out your RI code. It sounds like you have set your Delete code to 'Cascade'. Reverting the parent (deleting the new record from the buffer) would then automatically delete any child records.

HTH
Barbara