Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / The value 'xxx' in fie...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by techAx 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
  • Layan Jwei Profile Picture
    Layan Jwei 7,339 Super User 2024 Season 2 on at
    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
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,271 Super User 2024 Season 2 on at
    The value 'xxx' in field 'yyy' is not found in the related table 'abc1'.
    Hi @techAx,
     
    Can you share your code so we can help you?
     
     
    abc.yyy = abc1.yyy
     
    abc.yyy = abc2.yyy
     
    There is no relation between abc1 and abc2 
     
    abc has relation to both because it depends on the type of record-----(can you give me more details here?)

    Regards,
    Waed Ayyad
     
  • techAx Profile Picture
    techAx 34 on at
    The value 'xxx' in field 'yyy' is not found in the related table 'abc1'.
    Relations are like this:
     
    abc.yyy = abc1.yyy
     
    abc.yyy = abc2.yyy
     
    There is no relation between abc1 and abc2 
     
    abc has relation to both because it depends on the type of record
  • Layan Jwei Profile Picture
    Layan Jwei 7,339 Super User 2024 Season 2 on at
    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.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans