>>>Maybe I've gone braindead but 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. The record is in both files. The fields just need to be updated in the masterfile. I don't want to use a simple replace ..... command because there are 190 fields that must be updated out of about 280.
>>>
>>>Is there a way to do it or do I need to get busy typing? Any help would be appreciated.
>>>
>>>Brad Trim
>>
>>
>>SELECT AnotherFile
>>SCATTER NAME oNames MEMO
>>SELECT OneFile
>>GATHER NAME oNames
>>
>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.