Select Value Column

[MohamedSalem999]

Hello,

I have three tables with the same columns
The first table has fixed values and is the reference (Inventory)
The second table has the data I want (Control)
The third table that I need (Entry) to show me the row [Room Name] that is related to the first column [Department]
The first column is called [Departments] > Column Type: Enum
and contains repeated values
Second column [Room Name] > Column Type: Text
which is part of the first column

How can I show the values for each [Department] when requested?

[Steve · Accepted solution]

IN([Department], Control[Department])

[MohamedSalem999]

Thank you