How to give 3 fields in look up with filtering one with previous field in Dynamic AX 2012

1.      Create 3 fields for the table “FormTable” and add to form datasource.

2.      First field with relation in table level so automatically you will get the look up.

·         As FormTable.Fild1

3.      Second field with following lookup code, this look up filter with previous field.

·         As FormTable.Fild2

Public void lookup ()

{

    Query                   query = new Query();

    QueryBuildDataSource    queryBuildDataSource;

    QueryBuildRange         queryBuildRange;

     QueryBuildRange         queryBuildRange1;

    SysTableLookup          sysTableLookup;

     HRCCompGrid                  HRCCompGrid;

    ;

    //Create an instance of SysTableLookup with the form control passed in

    sysTableLookup = SysTableLookup::newParameters(tablenum(HRCCompRefPointSetupLine), this);

    //Add the fields to be shown in the lookup form

    sysTableLookup.addLookupfield(fieldnum(HRCCompRefPointSetupLine, RefPointId));

    sysTableLookup.addLookupfield(fieldnum(HRCCompRefPointSetupLine, RefPointSetupId));

    //create the query datasource

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

    //Only show LocalEndpoints for the current company

    queryBuildRange = queryBuildDataSource.addRange(fieldnum(HRCCompRefPointSetupLine, RefPointSetupId));

    select HRCCompGrid where HRCCompGrid.GridId ==SalaryAmend.GridId ;

//SalaryAmend.GridId is the FormTable.Fild1

    queryBuildRange.value(HRCCompGrid.RefPointSetupId);

//this select query makes the queryBuildRange values from another table for the datasource of another table

    //Assign the query to the lookup form

    sysTableLookup.parmQuery(query);

    // Perform lookup

    sysTableLookup.performFormLookup();

    // Don't call super()

    //super()

}

4.       Third field given a lookup with filtering on based of above 2 fields.

·         As FormTable.Fild3

public void lookup()

{

    Query query = new Query();

    QueryBuildDataSource queryBuildDataSource,qbds;

    QueryBuildRange qbr1,qbr2;

    SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(HcmCompensationLevel), this);

    sysTableLookup.addLookupfield(fieldnum(HcmCompensationLevel, CompensationLevelId));

    sysTableLookup.addLookupfield(fieldnum(HRCComp, RefPointId));

    sysTableLookup.addLookupfield(fieldnum(HRCComp, GridId));

    queryBuildDataSource = query.addDataSource(tableNum(HcmCompensationLevel));

    qbds = queryBuildDataSource.addDataSource(tableNum(HRCComp));

    qbds.joinMode(JoinMode::ExistsJoin);

    qbds.relations(true);

    qbr1 = qbds.addRange(fieldNum(HRCComp,GridId));

    qbr2 = qbds.addRange(fieldNum(HRCComp,RefPointId));

    qbr1.value(SalaryAmend.GridId);

    qbr2.value(SalaryAmend.RefPointId);

    sysTableLookup.parmQuery(query);

    sysTableLookup.performFormLookup();

    //super();HcmCompensationLevel

}