>>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
Mark McCasland
Midlothian, TX USA