[development-axapta] select a multiple fields from the customised lookup

[Girish Bhatkal]

Hi,
 i have written an customised lookup for "ItemId" field on a form say
"ABC". Here instead of the showing the records from the table "InventTable"
i am showing the lookup of the ItemId from  the "CustVendExternalItem"
table. it is as below
public void lookup(FormControl _formControl, str _filterStr)
{
   Query                   query   = new Query();
   QueryBuildDataSource    queryBuildDataSource;
   SysTableLookup          sysTableLookup;
   ;
   sysTableLookup  =
SysTableLookup::newParameters(tableNum(CustVendExternalItem),adt_StockReturn
Line_UPIDReturned);
   sysTableLookup.addLookupfield(fieldNum(CustVendExternalItem, ItemId));
   sysTableLookup.addLookupfield(fieldNum(CustVendExternalItem,
CustVendRelation));
   sysTableLookup.addLookupfield(fieldNum(CustVendExternalItem,
ExternalItemId));
   queryBuildDataSource =
query.addDataSource(tableNum(CustVendExternalItem));
   sysTableLookup.parmQuery(query);
   sysTableLookup.performFormLookup();
}
 this works fine. Now here on this caller form "ABC" i have another field
"ExternalItemId" . Now in the lookup below is a list of some the records
shown
     CustVendRelation     ItemId      ExternalItemId
      60001                3999            3939-30
      60002                3999            3939-20
      60003                3999          3939-49
now here among the list if i select the the second line , is it in some way
possible to update the ExternalItemId field on the caller form with
"3939-20".
  I know that the other option is to again write an lookup for the
externalItemId field and add the range for itemId. but i want to avoid this
step.
 i would appreciate any ideas to get this done.

cheers,
Girish


Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.