Lookup Code

  

    [FormControlEventHandler(formControlStr(BOMExpandSales, ChargeCode), FormControlEventType::Lookup)]

    public static void ChargeCode_OnLookup(FormControl sender, FormControlEventArgs e)

    {

        Query                   query;

        QueryBuildDataSource    queryBuildDataSource;

        QueryBuildRange         queryBuildRange; 

        SysTableLookup          sysTableLookup;

        sysTableLookup = SysTableLookup::newParameters(tablenum(MarkupTable), sender);

        sysTableLookup.addLookupfield(fieldnum(MarkupTable, MarkupCode), true);

        sysTableLookup.addLookupfield(fieldnum(MarkupTable, Txt));

        query                   = new Query();

        queryBuildDataSource    = query.addDataSource(tablenum(MarkupTable));

        queryBuildRange = queryBuildDataSource.addRange(fieldnum(MarkupTable, ModuleType));

        queryBuildRange.value(queryValue(MarkupModuleType::Cust));

        

        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();

    }