Dynamics Community Forum Thread Details

LogisticsAddressCountryRegion table custom lookup

I added countryRegionId field to my custom table. I just need two fields to my lookup. so, I added below code

public static void CountryOfOriginlookup(FormControl _formControl, LogisticsAddressCountryRegionID _filterStr)
{
Query query = new Query();
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(LogisticsAddressCountryRegion), _formControl);
QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(LogisticsAddressCountryRegion));

queryBuildDataSource.addRange(fieldNum(LogisticsAddressCountryRegion, CountryRegionId)).value(queryValue(_filterstr));

sysTableLookup.addLookupfield(fieldNum(LogisticsAddressCountryRegion, CountryRegionId));
sysTableLookup.addLookupfield(fieldNum(LogisticsAddressCountryRegion, ISOCode));

sysTableLookup.parmQuery(query);
}

I didn't add systablelookup.performFormLookup() as it is throwing an error "more than one lookup form opened" even after commenting super() in override\lookup method.

I tried event handler too. it's also showing same drop down.

But I am getting below drop down