I have 2 tables a Room table and I have a value list table that uses enumerations (enum) as the key and a name field.
I have value lists based on the enum but displaying the name field (unrelated to the room table).
So as would be expected the enum is stored in the Room::category field that uses the value list.
How would one concatenate the name field of that value list in the room table where the value list is used.
ValueList::enum actual data= 206
ValueList::name displayed data = Bathroom
Room::name date = Master
Room:category data = 206
Do not know where to start all I get is Master 206 when I concatenate.
The result I am looking for is "Master Bathroom"
Thanks in advance for any guidance.