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! Go to Solution.
The SELECT() is not constructed correctly. The correct form of the expression should be something like:
SELECT(Manifolds[ID], [Status] = "On Bid")
The SELECT() is not constructed correctly. The correct form of the expression should be something like:
SELECT(Manifolds[ID], [Status] = "On Bid")
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |