Hi Experts,
I add multi selected lookup to a field in SalesLine Table ,
when I open SalesTable form and I create new record , I get the lookup, I choose values .
But the problem is when I add second record , I get the same values selected as the first in lookup.
[Extensionof(formstr(SalesTable))]
public final class LookupValueClass_CAP_Extension
{
public SysLookupMultiSelectCtrl msCtrlCust;
public void init()
{
FormStringControl SaleLine_ManufacturingPlant_CAP;
next init();
SaleLine_ManufacturingPlant_CAP = this.design().controlname(formControlStr(SalesTable,SalesLine_ManufacturingPlant_CAP));
msCtrlCust = SysLookupMultiSelectCtrl::construct(this,
SalesLine_ManufacturingPlant_CAP ,
querystr(InventSiteQuery_CAP),
false,
[tableNum(InventSite), fieldNum(InventSite,SiteId)]);
this.parmMultiselectCtl(msCtrlCust);
}
public SysLookupMultiSelectCtrl parmMultiselectCtl(SysLookupMultiSelectCtrl _msCtrlCust = msCtrlCust)
{
msCtrlCust = _msCtrlCust;
return msCtrlCust;
}
//public class MultiSelectEH
//{
[FormDataFieldEventHandler(formDataFieldStr(SalesTable, SalesLine, ManufacturingPlant_CAP), FormDataFieldEventType::Modified)]
public static void ManufacturingPlant_CAP_OnModified(FormDataObject sender, FormDataFieldEventArgs e)
{
FormRun formRun = sender.datasource().formRun();
SysLookupMultiSelectCtrl msCtrlCust = formRun.parmMultiselectctl();
SalesLine salesLine = FormRun.dataSource(formDataSourceStr(SalesTable,SalesLine)).cursor() as SalesLine ;
salesLine.ManufacturingPlant_CAP = con2Str(msCtrlCust.getSelectedFieldValues(),';');
}
}
