Drop down lists
I have a drop down list from a customer table. The specify field values list the customer id for the first field and the business name for the second field. Showing values only from the second field. However, some of my customers don't have a business name they are listed by full name. Is there any way I can force the drop down to show the full name if there isn't a a business name? It would be great if they had a third field choice.
Also, is there any way to change the highlight color of the drop down lists? It is currenlty grey and I'd prefer a different color.
Thanks in advance for your help.