Dynamics 365 Community Blogs Finance blog for new developers How to show lookup on a for...

How to show lookup on a form's field in D365. #Dynamics #x++ #D365

Krishna Bhardwaj

Like ( 0 )

Report

Here is an example that shows how you can add look up on a field. I wrote my code in OnLookup event.

public static void LedgerParameters_FinDimName_OnLookup(FormControl sender, FormControlEventArgs e)
{
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(DimensionAttribute), sender);
sysTableLookup.addLookupfield(fieldNum(DimensionAttribute, Name));
Query query = new Query();
query.addDataSource(tableNum(DimensionAttribute)).addRange(fieldNum(DimensionAttribute, BackingEntityType)).value(queryValue(tableNum(DimensionFinancialTag)));
sysTableLookup.parmQuery(query);

//perform lookup
sysTableLookup.performFormLookup();
FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs;
ce.CancelSuperCall();
}