Similar configuration different reference display results

I have the following relations.

I obtain the expected relation and display from a Client record showing its related Commande. Unfortunately I cannot say the same from Tâch (Side note I do no know why on this graph the name is Tâch instead of Tâches)

On the scenario below I expect 3 results but I get 5.
The reference is REF_ROWS(“Commandes”, “Tâches ID”)
Where should I look to fix this?

I found the issue. It was related to the column Tâches set to number instead of Text.

Is it normal that a column set as Key can display text data while being set as a Number and fail the condition in a SELECT/Dereference?

1 Like