# Lookup in form control

**URL:** <https://www.dynamicsuser.net/t/lookup-in-form-control/37504>\
**Category:** Developer Forum\
**Created:** [May 8, 2012, 2:26pm UTC](https://www.dynamicsuser.net/t/lookup-in-form-control/37504 "2012-05-08T14:26:08Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![venky20mca](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@venky20mca](https://www.dynamicsuser.net/u/venky20mca)\
**Post date:** [May 8, 2012, 2:26pm UTC](https://www.dynamicsuser.net/t/lookup-in-form-control/37504/1 "2012-05-08T14:26:08Z")

</div>

hi,

i have to build a lookup in that ineed to show the InvoiceAccount,AmountCur from CustOpenTrans and InvoiceId ,Voucher from CustTran. for that wrote teh logic as shown below. but in second and third controls(InvoiceId and Voucher)it is showing duedate and amount from the custTransopen table.

can any one suggest the exact way to achieve this.

sysTableLookup = SysTableLookup::newParameters(tablenum(CustTransOpen),this);  
qbds = query.addDataSource(tablenum(CustTransOpen));  
qbds1 = qbds.addDataSource(tablenum(CustTrans));

qbds1.addLink(fieldnum(CustTransOpen,AccountNum),fieldnum(CustTrans,AccountNum));

qbds1.joinMode(JoinMode::InnerJoin);  
qbds1.relations(true);

queryBuildRange = qbds.addRange(fieldnum(CustTransOpen,AccountNum));  
queryBuildRange.value(queryvalue(P\_PDC.InvoiceAccount));

sysTableLookup.addLookupfield(fieldnum(CustTransOpen,AccountNum));  
sysTableLookup.addLookupfield(fieldnum(CustTrans,Invoice));  
sysTableLookup.addLookupfield(fieldnum(CustTrans,Voucher));  
sysTableLookup.addLookupfield(fieldnum(CustTransOpen,AmountCur));

sysTableLookup.parmQuery(query);  
sysTableLookup.performFormLookup();

Args args = new Args();  
FormRun itemLookUp;