Monday, May 30, 2016

X++ code For MultiselectLookup form from MultipleTables in ax 2012

public void lookup()
{
    Query query;
    QueryBuildDataSource qbds1,qbds2,qbds3;
    SysLookupMultiSelectCtrl msc;
   
    super();

    query = new Query();
    qbds1 = query.addDataSource(tableNum(CustTable));
    qbds1.fields().dynamic(NOYES::Yes);
    qbds1.fields().addField(fieldNum(CustTable,AccountNum)); //Lookupform contains only accountnum

    qbds2 = qbds1.addDataSource(tableNum(DirPartyTable));
    qbds2.fields().dynamic(NOYES::Yes);
    qbds2.fields().addField(fieldNum(DirPartyTable,Name)); //Lookupform contains only Name


    qbds3 = qbds2.addDataSource(tableNum(LogisticsElectronicAddress));
    qbds3.fields().dynamic(NOYES::yes);
    //Lookupform contains only Locator 
    qbds3.fields().addField(fieldNum(LogisticsElectronicAddress,locator));
   
    qbds2.relations(true);
    qbds3.relations(true);
    msc=SysLookupMultiSelectCtrl::constructWithQuery(element,StringEdit,query);


}

No comments:

Post a Comment

Export a copy of the standard user acceptance testing (UAT) database

 Reference link: Export a copy of the standard user acceptance testing (UAT) database - Finance & Operations | Dynamics 365 | Microsoft ...