Jim,

Thanks for all your help on that last episode of updating fields. I finally understood what you were meaning after some HOURS of thought and study. Now I have a functional form that I can make improvements on. Thanks again.

Elgin


>Elgin,
>
>You need to revers the relationship to get the code to work. You need to be scanning cpcb with a relation from it into cliqcnv.
>
>As for not hardcoding the field names then use AFIELDS() to get teh field names. COPY TO will NEVER give you anything but 0's, there is no way to get COPY TO to do anything else. To contrl the output of the zeros you need to build your own creation of the text file as I showed. You should be able to use yur afields() array to build the ?'s inside of the scan loop. You may need to make it a series starting with one ? and then followed by a series of ?? for each field so you can chekc the afields array for the data type to deterimine the separators and delimiters to be be used.
>
>COPY TO is very nice and easy but your requirement for the 0 values to be blank precludes your ability to use that command.