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

All responses (4)

Answers (0)

Layan Jwei 7,349 Super User 2024 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
Suggested answer

Waed Ayyad 6,408 Super User 2024 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
techAx 34 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
Layan Jwei 7,349 Super User 2024 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