Finance | Project Operations, Human Resources, ...

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

(1) Share

Report

Posted on by techAx

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

I have the same question (0)

All responses (4)

Answers (0)

Layan Jwei 7,997 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 8,847 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
techAx 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Layan Jwei 7,997 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates