This content has been marked as final. Show 2 replies
I'm trying to have a text box that shows the description of a specified code
I want to write something along the lines of
=[PI Description] where [PI Code] = 'GK300'
This will always show the Description of the Code GK300.
What I dont want to do (but it works) is
=If([PI Code]='GK300', [PI Description])
as this will only show the description if GK300 is selected.
I hope this makes sense. Any ideas?