I must be dumb I am sure I have done this before but for the life of me I cannot work it out.
I have a Military Units file which has a Unit Name in Full description.
When a service persons record is started there is a dropdown to select the Unit BUT the Unit Codes are not really intuitive so I need to display not only the Unit code but the Description as well.
I dont want to STORE the whole verbose description just the code from the connected file.
I can display the description in a table etc etc but when it comes to actually SETTING the code in the first instance how do I get the dropdown to display both code and description but only store the code ?