What is the best way to choose a company name in a drop-down list in one field and have another field display that company's logo?
I originally coded this process many years ago using a calculation field and series of "case" statements within the field definition. That worked fine when there were only a handful of choices. However, now that this list has expanded to 20+ companies, adding new companies and their logos to the list is extraordinarily cumbersome.
The logos themselves are stored as Global fields in a related table. There are four separate fields within each customer's record where I need to do this.
There has to be a better way to do this via a script instead of a calculation field, but I'm not sure of the best way to approach this.
Help will be appreciated!