Hi - not hopeful about this but maybe someone has a clever way to do this?
I'm creating a date entry layout for sales orders, and the users would like to be able to add items three ways:
- From a search box pop-up: all straightforward
- From an auto-completing drop-down list of product codes which also shows the product name as a second field: also straightforward
- From an auto-completing drop-down list of product names which also shows the product codes, but with the product code shown on the LEFT of the product name (i.e. visually the same as option 2, but auto-completing on name instead of code)
I have tried using a calculated field to concatenate CODE & " | " NAME and then show this second field instead of the name, but then the autocomplete breaks.
So, show code then name, but autocomplete on name - is it possible?