Dynamics Community Forum Thread Details

Yes, you can write a lookup method on web control, something like below -

Note - This is NOT for vendor drop down.

protected void Account_Lookup(object sender, AxLookupEventArgs e)
{
AxLookup lookup = e.LookupControl;

        // Create the lookup dataset - we will do a lookup in the Contact person table
        using (BCProxy.SysDataSetBuilder sysDataSetBuilder = BCProxy.SysDataSetBuilder.constructLookupDataSet(
            this.AxSession.AxaptaAdapter, TableMetadata.TableNum(this.AxSession, "VendBankAccount")))
        {
            // Set the run time generated data set as the lookup data set
            lookup.LookupDataSet = new Microsoft.Dynamics.AX.Framework.Portal.Data.DataSet(this.AxSession, sysDataSetBuilder.toDataSet());
        }

        BCProxy.Query query = lookup.LookupDataSet.DataSetViews[0].MasterDataSource.query();
        query.allowCrossCompany = true;
        query.addCompanyRange(GetCompanyLine());
        using (BCProxy.QueryBuildDataSource qbds = query.dataSourceNo(1))
        {
            using (BCProxy.QueryBuildRange range = qbds.addRange(TableDataFieldMetadata.FieldNum("VendBankAccount", "VendAccount")))
            {
                DataSetViewRow PaymentLine = this.dsEPPaymentEdit.GetDataSourceView("PaymentLine").DataSetView.GetCurrent();
                if (PaymentLine != null)
                {
                    using (IAxaptaRecordAdapter record = asuPaymentLine.GetRecord())
                    {
                        if (record != null)
                        {

                            AppProxy.VendTable vendTable = AppProxy.VendTable.findByCompany((string)record.GetField("Company"),(string)record.GetField("Account"));
                            // Filter the lookup
                            range.value = Convert.ToString(vendTable.AccountNum);
                            range.status = (int)BCProxy.RangeStatus.Hidden;
                        }
                    }

                }
            }

        }

        lookup.LookupDataSet.Init();

        // Specify the lookup fields used
        lookup.Fields.Add(AxBoundFieldFactory.Create(this.AxSession, lookup.LookupDataSetViewMetadata.ViewFields["AccountId"]));
        lookup.Fields.Add(AxBoundFieldFactory.Create(this.AxSession, lookup.LookupDataSetViewMetadata.ViewFields["Name"]));
        lookup.Fields.Add(AxBoundFieldFactory.Create(this.AxSession, lookup.LookupDataSetViewMetadata.ViewFields["AccountNum"]));

        // Specify the select field
        lookup.SelectField = "AccountId";
    }

#endregion

Call it as below -

<dynamics:AxBoundField DataField="Account" DataSet="EPPaymentTableEdit" DataSetView="PaymentLine" SortExpression="Account" AutoPostBack="true"
OnDataChanged="Account_DataChanged" LookupButtonDisplaySettings="Always" OnLookup="Account_Lookup">
</dynamics:AxBoundField>

You can override dataSetLookup on dataset as well.

Community site session details

Customization on EP

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the August Top 10 Community Leaders

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates