LinkedIn
Twitter
I am creating a facilities management app and am using three tables.
1) The Room Repair Request table (relevant columns: Repair ID (key), Building - Ref Type, pointed to Buildings Table, Room - Ref Type, pointed at Rooms table
2) The Building table (relevant columns: Building ID (key) and Building Name (Label)
3) The Rooms Table (relevant columns: Room ID (key) the Room_Space =Name or Number of Room (label) and Building-contains the building the room is in.
In my Room Repair Request form, I have created a column for Building (Type Ref, Ref Table "Buildings"),. This works great, the drop down shows the values from the referenced table
I want the Rooms column to show only the values associated with the Building selected. I have set this column up as (Type Ref, Ref Table "Rooms") and then used the
SELECT(
Rooms[ROOM_SPACE],
[BUILDING] = [_THISROW].[Building]
)
My dropdown list for Room keeps coming back blank. I'm at a total loss and have spent hours on this. I'm sure it is a simple fix but I have tried every permutation I can find online and still the same.
Any help would be greatly appreciated
