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