>>>Append works regardless of field order in the 2 tables involved. The only data that gets appended are those fields that are the same name in both tables.
>>
>>But Append doesn't have a scope on it (does it?). How do I do it if I just want to append the current record? I guess I could use the FOR clause but I thought that on a large source table it would be slower than just specifing the current record somehow.
>
>You can:
>
>Copy Next 1 to TempDBF
>Select Table2
>Append from TempDBF
>erase tempdbf.dbf
>erase tempdbf.fpt && if necessary

Thanks Mark,

That is the code that I concluded is what I want. I was trying to do it without creating the tempdbf but I guess there is no way around it.