generator-example-getdata from other table

1. main form
2. call form

Purchase.txt (main form)
0.51,PURCHASE_HEADER.SUPPLIER,combo,18,18,Supplier,,{colSpan}3{/colSpan}{getJson} tableRead?table=VENDOR&fields=RECORDID,NAME&where=where status:`A` &format=S,S&callback=?{/getJson} {onChange}s10=this.value;s= 'tableRead?table=VENDOR&fields=ADDRESS&key=RECORDID&value='+s10+'&format=S&callback=?&db='+DATABASE ; $.getJSON(s,function(data) {if (data[0]){   s= data[0][0];      s=s.replace(new RegExp('<z><z>','g'), '\r');   _refreshv('PURCHASE_HEADER.CONTACT_ADDRESS',s);}});{/onChange} {refresh}currentEntity=_lookup('this.id');{/refresh}


PurchsaeConfig.txt  (main form)

appendData0=input.jsp?input:purchaseSalesOrderList.txt&config:purchaseSalesOrderListConfig.txt&mode:CHOICE  <remark>Call form</remark>
appendData0Caption=Creator
appendData0Source=SOQTYOS              <remark>After get the key from call from</remark>
appendData0TargetKey=PO.SODP_RecordID
appendData0HeaderSource=SALES_ORDER,COMPANY,DIVISION,SALES_CODE,SUPPLIER,SUPADD, SUPTEL,SUPCON,SOADD,CUSNAM,SOCON,SOTEL,PAYT,SALES_ORDER,SUPPLIER_REF
appendData0HeaderSourceFormat=S,S,S,S,S,S,S,S,S,S,S,S,S,S,S
appendData0HeaderTarget=PURCHASE_HEADER.SALES_ORDER,PURCHASE_HEADER.COMPANY,PURCHASE_HEADER.DIVISION, PURCHASE_HEADER.SALES_CODE,PURCHASE_HEADER.SUPPLIER,PURCHASE_HEADER.CONTACT_ADDRESS, PURCHASE_HEADER.CONTACT_NAME, PURCHASE_HEADER.CONTACT_TEL ,PURCHASE_HEADER.SHIP_TO_ADDRESS, PURCHASE_HEADER.COMPANY_NAME, PURCHASE_HEADER.SHIP_TO_CONTACT, PURCHASE_HEADER.SHIP_TO_TEL,PURCHASE_HEADER.PAYMENT_TERMS,PURCHASE_HEADER.OUR_REF_NO,PURCHASE_HEADER.YOUR_REF_NO
appendData0ActionAfter=currentEntity:_lookup('PURCHASE_HEADER.SUPPLIER');

purchaseSalesOrderListConfig.txt (call form) Source data

key=sosta
keyValue='A'
where=where SOqty>poqty  and SUPPLIER like `^'+parent.currentEntity+'^` and FIND_IN_SET(TRIM(SODP_RecordID),"'+parent.currentChoose+'"):0