The relation can be seen as a door to open the path between the two Sheets you’re linking above. The visual presentation there shows that there’s one row or multiple rows found according to your Settings, and it would take a random column in the destination sheet to show on the screen.
The actual value you can use, let’s say for displaying, is through a lookup/single value column on top of the relation.