It should be obvious this but I'm missing something simple.
I have a layout where I want to choose an item from a related table. The relationship has an ID (the field for the relationship) and a friendly name. I would like to be a able to choose the friendly name and then have the ID filled in because this is the one that will do the work.
At the moment I choose the ID and then the friendly name appears on my layout but I can't seem to select the friendly name and have to ID appear
How do I do this?