I have a list in a table called Stock items.
The stock items are categorised into packaging, raw and selling items.
I have another table which is used to do a mock recall on a selling product.
Rather than create a new table with only selling items I want to filter the dropdown Ref column in the recall table.
I tried a SELECT expression
Ref Raw and Selling Stock Items[Stock Item],
[Selling/Raw] = “Selling”,
In the Valid_if section and this appeared to work but I have little triangles with exclamations next to my results in my dropdown.
What could be causing that?