Relation "How to" (if it's possible)

[DavidTARDIVEAU]

Hello,

I’d like to get a value from a sheet which is not in the main one.
As you can see on the picture, i’d like to get a value, and not an inline list (with the Relation Component).

Thanks.

[Darren_Murphy]

• Create a Single Relation from your Users table to your Rooms table, using the Group column in each
• Add a Lookup column to your Users table, fetching the Room number via that relation

[DavidTARDIVEAU]

Thanks a lot. Perfect.
The solution with an image for the community.