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.
The value 'xxx' in field 'yyy' is not found in the related table 'abc1'.
Hi Tech,
Please explain what do you mean by "it depends on the record". Maybe we can help you with the design (assuming these tables are custom and created by you)
Also if you have screenshots with sample data, it will let us understand more.
Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
The value 'xxx' in field 'yyy' is not found in the related table 'abc1'.
Hi Tech,
is there a relation between abc1 and abc2? and which one in the main table?
I'm assuming this is the base table
ABC1(table)
yy
1
2
3
then you have this
ABC2(table)
yy
1
2
relation
abc1.yy=abc2.yy
is this correct?
Now for ABC? should it contain records from ABC1 or ABC2? why did you have to make relation to both?
Also to know if the issue is from your lookup or not, you can simply comment the code out and see.
Thanks,
Layan Jweihan
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.