Filtering dropdown values from reference table

I have a table (Devices) that has a Station Id column that references another table (StationIds). I’m trying to filter the values from for the Station Id column to only show StationIds for the selected project. This seems to be working, but I’m seeing these yellow “warning” icons.

To filter, I set this expression on the Valid If property of the Station Id reference column in Devices:
SELECT(StationIDs[StationID], [Project] = [_THISROW].[Project Number], true)

What did I miss?

The yellow triangles implies a broken ref. Please check your parent table and child table and ensure that the ref column’s values are inline with the key column values of the parent table.


That was it. Thanks!

1 Like

You’re welcome