Skip to main content
Dynamics 365 Community / Forums / Finance forum / The value 'xxx' in fie...
Suggested answer

The value 'xxx' in field 'yyy' is not found in the related table 'abc1'.

editSubscribe (0) ShareShare
ReportReport
Posted on by 34
Hi
 
I have an issue where I am getting this message The value 'xxx' in field 'yyy' is not found in the related table 'abc1' when I want to select record in a grid.
I have overriden lookup method with some query conditions that I dont think are relevant.
 
The thing is that my table 'abc' that contains this field 'yyy' has 2 relations, one to table 'abc1' and another to 'abc2' using the same field ('yyy') and it is searching by default only in abc1 and when I select record from abc2 it says that it doesnt exist in table abc1.
Why is that?
 
Thanks in advance