Foreign key value shown

Table “Pedido de Venda” has two foreign key fields (“Cliente”, “Representante”) linking to the same “Pessoa” table.
I would like Metabase to display “Pessoa”.“Nome” field but it will do it only for “Representante”, “Cliente” will be kept as the original “Pedido de Venda”.“CD_Cliente” field.

Hi @kelsen.faria

That’s a known issue - but I cannot find an earlier issue (I’m sure I found it at one point), so I’m just going to link to this - go and click the “Subscribe”, so you get notifications, when anything changes: