>>I am working on a form with buffering set to optimistic row buffering set on. When I do an append blank on the table and then do a tablerevert the record is still there with the default values I have selected still showing. Anything I have KEYED on the form after the append blank BUT before the tablerevert is gone. Any help or suggestions would be greatfully appreciated. And yes, I'm a novice :)
>
>Do you have anything in the insert trigger code that does a tabelupdate() for you or otherwise moves the record pointer which would also do a tableupdate?

I have no insert triggers set for this table. If I do an append blank and move a value to the key either by a field default or immediately after the append blank would this cause a problem??