I want to make select stament that filter based on criteria 3 colums :
The Case :
Asset Table:
Plant Vs Location Table:
I want to make LoV in valid if in new Location Description that refer to Plant Vs Location and filtered only shown that doesnt equal to in this row 'location description' in Asset Table :
Example :
Asset Table:
Asset Table:
Maybe the formula something like this
Asset Table
SELECT(Plant Vs Location[Location Description], AND([_THISROW].[Plant Description] = [Plant Description]), NOT(IN([Location Description))
how to do that
Solved! Go to Solution.
Plant Vs Location[Location Description] - LIST([Location Description])
Plant Vs Location[Location Description] - LIST([Location Description])
@Joseph_Seddik Thank you PERFECT!
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |