Skip to main content

Notifications

Announcements

No record found.

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

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

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
  • Layan Jwei Profile Picture
    Layan Jwei 4,815 Super User 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 3,904 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 4,815 Super User 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
     

     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans