I have a native table in a DBC.

When I...

USE tablename
BEGIN TRANSACTION
APPEND FROM temptable
END TRANSACTION

the appended record(s) go away.
What gives? On top of that, when I try to do the equivalent from a form with table buffering and TABLEUPDATE, not only does the record go away but I get a message saying that the index no longer matches.

Any ideas?

Thanks,
Larry