Table relation to item category code

tompynation

"Item Category".Code WHERE (Code=FILTER(<>F))

If i add the above table relation to a custom field...

Shouldnt this lookup then show all Item category code's exept the one where the code is 'F'?

Cause its not working, i just see all the codes

ara3n

I suggest to create a new boolean field and mark the ones you don't want to see
In your table relationship set
where New Field=filter(false))