>And he might want to actually add the record to OneFile...
>
>
>SELECT AnotherFile
>SCATTER NAME oNames MEMO
>SELECT OneFile
>APPEND BLANK
>GATHER NAME oNames MEMO
>
>
>>>>make a good backup first because i didn't tested it.
>>>
>>>Ha-ha, you'll lose MEMO content on your replace. Good point about a backup :)
>>
>>:-)
>>I forgot MEMO at the end of GATHER.
Here the request:
[quote]
I need to know how to
update fields in a single record in a file from a single record in another file where the field names are the same but in different order
[/quote]
Not Insert a new record :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.