Help with Enum List Ref Type

I have an Enum List, Ref type connect to a Manifolds Table

In the verify if, I put in Manifolds[ID] and it brings in all the manifolds

I want to limit the selection to only Manifolds with the [Status] of "On Bid"

SELECT(Manifolds[ID],(Manifolds[Status])=LIST("On Order")
)

Returns no options even though there should be several, I have written the logic 20 different ways and I am not seeing why none are come through,  Is there any special considerations?

Solved Solved
0 1 54
1 ACCEPTED SOLUTION

The SELECT() is not constructed correctly.    The correct form of the expression should be something like:

SELECT(Manifolds[ID], [Status] = "On Bid")

 

View solution in original post

1 REPLY 1

The SELECT() is not constructed correctly.    The correct form of the expression should be something like:

SELECT(Manifolds[ID], [Status] = "On Bid")

 

Top Labels in this Space