Preview:
    SysTableLookup SysTableLookup = SysTableLookup::newParameters(tableNum(VendPackingSlipJour),_formControl);
    QueryBuildDataSource  qbds, qbdsCOC;
    Query query = new Query();

    qbds = query.addDataSource(tableNum(VendPackingSlipJour));
    qbds.addRange(fieldNum(VendPackingSlipJour, PurchId)).value(NW_CertificationOfCompletionHeader.PurchId);
    //qbds.addRange(fieldNum(VendPackingSlipJour, PackingSlipId)).
    //    value(SysQuery::valueNot(NW_CertificationOfCompletionHeader.PackingSlipId));

    qbdsCOC = qbds.addDataSource(tableNum(NW_CertificationOfCompletionHeader));

    qbdsCOC.addLink(fieldNum(VendPackingSlipJour, PackingSlipId),
        fieldNum(NW_CertificationOfCompletionHeader, PackingSlipId));
    qbdsCOC.joinMode(JoinMode::NoExistsJoin);
   
    SysTableLookup.addLookupfield(fieldNum(VendPackingSlipJour, PackingSlipId),true);
    SysTableLookup.addLookupfield(fieldNum(VendPackingSlipJour, PurchId));

    SysTableLookup.parmQuery(query);
    SysTableLookup.performFormLookup();
}
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter