>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) >>
> 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