This problem seems to be re-occuring with some regularity with different people. I am having a very similar problem with a remote view still. If I take the trigger off from the table on the back end that is being inserted into all of the records append fine, but with the trigger on, a small percentage of the records seem to disappear during the tableupdate. The view has all of the records, but the back end table doesn't get them all. No errors are returned either.

This may just be that a number of us are doing the same stupid thing wrong, or maybe there is a real issue with VFP.