>>What is the easiest way to append all the fields from one (current) record in a table to a second table? The table I want to copy the fields to contains more fields than the first and the order of the matching fields does not corrispond to the order of fields in the first table.
>>
>>I've been using insert but it makes for very large statement because I have to spellout all the fields in both tables.
>>
>>Is there something like Append which matches fields in the target table regardless of their order?
>>
>>TIA
>>
>>Ken Ward
>
>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.