Skip to main content
Suggested answer

Error on Lookup

editSubscribe (0) ShareShare
ReportReport
Posted on by 43
Hi I do have a lookup on a custom field on the sales table. It´s a lookup on a custom table
 
The lookup open like it should be, I can filter on all 4 Lookup fields but when I select a value I get an error that the value cannot be found
 
    sysTableLookup=SysTableLookup::newParameters(tablenum(CEM_CRM_Opportunity),this);    sysTableLookup.addLookupfield(fieldnum(CEM_CRM_Opportunity,Name));    sysTableLookup.addLookupfield(fieldnum(CEM_CRM_Opportunity,Opportunitynumber));    sysTableLookup.addLookupfield(fieldnum(CEM_CRM_Opportunity,StatusA));    sysTableLookup.addLookupfield(fieldnum(CEM_CRM_Opportunity,StatusB));    sysTableLookup.addLookupfield(fieldnum(CEM_CRM_Opportunity,OpportunityId));    qbds = query.addDataSource(tablenum(CEM_CRM_Opportunity));    sysTableLookup.parmQuery(query);    sysTableLookup.performFormLookup();
I open the lookup, filter on the name column and select the record.
 
Now the error comes up:
The value '52451 SKARPSKYTTEN, LUND' in field 'Opportunity Id' is not found in the related table 'Opportunity'.