Add a lookup method to string edit and belows will help you. public void lookup() { Str Secilecek;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(PurchTable), this); Query query = new Query(); QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(PurchTable)); QueryBuildRange queryBuildRange = queryBuildDataSource.addRange(fieldNum(PurchTable, PurchId)); QueryBuildRange queryBuildRange1 = queryBuildDataSource.addRange(fieldNum(PurchTable, AccountNum)); While Select PurchTable Where PurchTable.PurchaseType == 3 // Open Order { if(PurchTable) { Secilecek+=PurchTable.PurchId+","; } } if(Secilecek!='') { queryBuildRange.value(Secilecek); sysTableLookup.addLookupfield(fieldNum(PurchTable, PurchId)); sysTableLookup.addLookupfield(fieldNum(PurchTable, AccountNum)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); } Super(); } Yavuz YILDIZ ERP Developer Star Group Glass Processing __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/