D365

 If you want to add a subquery result in the lookup x++, Kindly follow the following steps; 1 - You have to create a temp table;   TableTmp tableTmp; 2- Add all records of TableA in the temp table as show below;        tableTmp.clear();             while select TableA              {                 tableTmp.RequestId = TableA .RequestId;                       tableTmp.doinsert();                   } 3- Remove the record you don't need in the tempTable, Which exists in TableB as shown below;     while select TableB             {                    select firstonly tableTmp where tableTmp.RequestId == TableB.RequestId;             ...

If you to populate the grid through code, You must create a temp table in the project. 1- For creating the temp table, filter any temp table in AOT like BOMCalcTransTmp  Table. 2- Duplicate the  BOMCalcTransTmp table in the project and change the name of the table and the fields of the table as you like. 3- Now add the temp table  BOMCalcTransTmp in the Datasource field of the grid. 4- Now the main part is how to populate the grid. You can populate the grid on the init() method or on the button clicked method as shown in the code below; 5- Kindly make the temp table  BOMCalcTransTmp table-type   InMemory . BOMCalcTransTmp bomCalcTransTmp;                 while Select bOMCalcTrans where bOMCalcTrans.CalcType == ItemCalcType::Process                 {                     bomCalcTransTmp.clear();            ...

 If you want to write a lookup through the event handler. Follow the following code; [FormControlEventHandler(formControlStr(SalesTable, SalesLine_CostSheetId), FormControlEventType::Lookup)]     public static void SalesLine_CostSheetId_OnLookup(FormControl sender, FormControlEventArgs e)     {         Query                                   query;         QueryBuildDataSource                    qbdsFabCostSheetsCalculation;         QueryBuildRange                         queryBuildRange;         SysTableLookup                          sysTableLookup;         FormControlCancelableSuperEventArgs...

 If you do not see the w3wp process in the attach to process menu in the Visual Studio. Follow the following steps: 1- Search Services by pressing the window + S button. The following window is open as shown below; 2-  Start the W3C Logging Service as shown in the above image. 3- Now restart Visual Studio and check your w3wp.exe Service is available. Thanks.