Dynamics Community Forum Thread Details

Tmp table is empty when performing lookup

I wanted the user to choose a table and then I show all fields in that table in a lookup...

so I created a Tmp table with one string field and this method to load the values -columns names- into the Tmp table:

 private void loadTableFields()
    {
        DYNADDVFieldTableTmp  dYNADDVFieldTableTmpRecord;
        DictTable             dictTable;
        fieldId               fieldId;

        switch(Grid_TableOption.selection())
        {
            case DYNADDVTableOption::SalesTable:
                dictTable  = new DictTable(tableNum(SalesTable));
                fieldId    = dictTable.fieldNext(0);
                break;

            default:
                FieldComboBox.clear();
                break;
        }
        
        while (fieldId)
        {
            dYNADDVFieldTableTmpRecord.clear();
            dYNADDVFieldTableTmpRecord.Field = dictTable.fieldObject(fieldId).name();
            dYNADDVFieldTableTmpRecord.insert();

            fieldId = dictTable.fieldNext(fieldId);
        }

        element.redraw();
    }

I override the "Table" field lookup method:

public void lookup(FormControl _formControl, str _filterStr)
    {
         SysTableLookup loopUpTable = SysTableLookup::newParameters(tableNum(DYNADDVFieldTableTmp),_formControl);
         Query                               q;
         QueryBuildDataSource                qbds;

         q           = new Query();
         qbds        = q.addDataSource(tableNum(DYNADDVFieldTableTmp));
              
         loopUpTable.addLookupField(fieldNum(DYNADDVFieldTableTmp, Field));

         loopUpTable.parmQuery(q);
         loopUpTable.performFormLookup();
         element.redraw();
         _formControl.update();
     }

but this is the result I get.. the lookup is empty!