It looks like one (or more) imported records are violating rules (referential integrity) defined in your DBC.

After the APPEND FROM records are in memory (note that BEGIN TRANSACTION buffers them regardless of the buffering mode that you are working on.) When you execute END TRANSACTION foxpro is trying to commit those records and it looks like one (or more) records does not satisfy your constraints.

>Upon append, the record shows in the browse.
>After END TRANS, I do a browse and nothing shows. I escape and browse again and then the record is gone.
>
>I do not do tableupdate, because I am not currently using buffering while testing this.
>
>>Try the following code so you can detect where is it that you are loosing your records.
>>
>>USE tablename
>>
>>BEGIN TRANSACTION
>>APPEND FROM temptable
>>browse && do you see your new records?
>>END TRANSACTION
>>browse && do you still see your new records?
>>
>>? tableupdate( 2, .T. )
>>USE
>>
>>USE tablename
>>browse && do you still see your new records?