The relation just establishes a link between the two tables. If you need values from the target table for display purposes, then you need to add one or more Lookup columns that fetch the appropriate values via the relation. In this case, you should ensure that your relation is a single relation (“Match multiple” is not checked).
2 Likes