>hi all,
>
>any idea ,help
>
>vi myform how i can choice 2 fields from 2 tables via 2 textbox,
>the 2 fields did not have the same name,
>
>i do that as programmer via this code under,
>
>i need to let the user choise the 2 fieled&&2 fields have same type(numaric)

>CLOSE all
>USE bill in 0
>USE contact in 0
>
>replace IN contact ;
>   FOR cc==LOOKUP(bill.cc,cc,bill.cc) AND NOT EOF('bill') ;
>   val with VAL(bill.bill_value)
>

>
>i need to do that via my form as
>

> thisform.text1.value=bill.field&& any table and any field
> thisform.text2.value=contact.field && any table and any field
>

You can use macro substitution. Here's an example:

lcBillFld = ALLTRIM(thisform.text1.value)
lcContactFld = ALLTRIM(thisform.text2.value)

REPLACE &lcContactFld WITH &lcBillFld in Contact