Hi Metin,
thank you ,
i try it ,it works , but what i need to replace exfile.newvalue with xval.bill_value where xval.lcField=exfile.lcField
your code copy all value from xval.lcField to exfile.newvalue.
thanks.
>Hi Muhammed,
>
>CLOSE all
>
>USE alltrim(thisform.text5.value) in 0
>USE alltrim(thisform.text6.value) in 0
> lcField = alltrim(thisform.text1.value)
>
>xval=alltrim(thisform.text5.value)+"."+lcfield
>
>
>xfile=alltrim(thisform.text6.value)
>
>xval2=alltrim(thisform.text5.value)+"."+lcfield
>
>replace IN (xfile) ;
> FOR EVAL(lcField)==LookUp(&xval, EVAL(lcField), &xval2) AND NOT EOF(alltrim(thisform.text5.value));
>with VAL(eval(xval2))
>
>
>these codes so complex I prefer more simple codes. my advice use seek or locate commands instead of lookup. It will so easy...
>It's possible my corrects won't run. because I don't have change to try and I said that "your codes too complex"