Lookup In AX Form

1. ) Lookup with join i wanna lookup with value that i have got from join 3 tables. I already get these value from a methods. the methods cannot be filtered in lookup, so i use these new table to lookup with my datasource in form. *field table can be filtered // add by Vina // vn_VendLedger is inserted from table VendLedger in JOb : GetDisplayAccountFromPostingProfile VendLedger vendledger; vn_VendLedger vn_vendledger; while select vendledger { vn_VendLedger.Cancel = VendLedger.Cancel; vn_VendLedger.DimSettlementCtrlType_RU = VendLedger.DimSettlementCtrlType_RU; vn_VendLedger.Name= VendLedger.Name; vn_VendLedger.PostingProfile= VendLedger.PostingProfile; vn_VendLedger.PostingProfileClose= VendLedger.PostingProfileClose; vn_VendLedger.Settlement = VendLedger.Settlement; vn_VendLedger.DisplayAccount=VendLedger.displayaccount(); vn_VendLedger.insert(); } then, lookup in textbox that contain field : public void lookup() { // add by Vina // vn_VendLedger is inserted from table VendLedger in JOb : GetDisplayAccountFromPostingProfile Query query = new Query(); QueryBuildDataSource qbds; QueryBuildDataSource qbdsJoin; SysTableLookup sysTableLookup = sysTableLookup::newParameters( tableNum(vn_VendLedger), this); ; qbds= query.addDataSource( tableNum(vn_VendLedger)); sysTableLookup.parmQuery(query); sysTableLookup.addLookupfield( fieldNum(vn_VendLedger, PostingProfile)); sysTableLookup.addLookupfield( fieldNum(vn_VendLedger, name)); sysTableLookup.addLookupfield( fieldNum(vn_VendLedger, displayaccount)); sysTableLookup.performFormLookup(); } 2. ) Lookup with calling the methods. It direct call the methods in table to get the value that i want. public void lookup() { // add by Vina // vn_VendLedger is inserted from table VendLedger in JOb : GetDisplayAccountFromPostingProfile Query query = new Query(); QueryBuildDataSource qbds; QueryBuildDataSource qbdsJoin; SysTableLookup sysTableLookup = sysTableLookup::newParameters( tableNum(VendLedger), this); ; qbds= query.addDataSource( tableNum(VendLedger)); sysTableLookup.parmQuery(query); sysTableLookup.addLookupfield( fieldNum(VendLedger, PostingProfile)); sysTableLookup.addLookupfield( fieldNum(VendLedger, name)); <span style="background-color: rgb(51, 204, 255);"> sysTableLookup.addLookupMethod(tableMethodStr(VendLedgerAccounts, summaryledgerdimension)); </span> sysTableLookup.performFormLookup(); }