Lookup in form control

Finance and Operations/AX Developer Forum
1

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;