I am currently doing a simple calculated value on my form to take the value of a lookup field and return the column beside it in real time on the form. The logic is sound but the issue I get is the lookup returns the ID number as well as the desired name which results in the calculated value never matching the list.
The value on my list is Sub-Terrain #1 Sub contractor Crew. The 433 is the ID number on the list and the ;# is just extra helpful. The question I have is how can I remove the 433:# from my lookup value for my calculated field can match the value correctly. When I fill the form out the value comes in currently as Sub-Terrain...
thanks for the help. I hope this makes sense.