Customizing lookup dropdown contents display style.

Customizing lookup dropdown contents display style.

I have a form to add records to a table. Part of this form is a lookup list displayed as a drop-down menu with data imported from a table of employees. I currently have it configured to show FirstName LastName - IDNumber. What I would like, is to add a column called PreferredName that is not required, that way, when we have someone that goes by a name other than how they are typically listed (Someone named Otto actually goes by Dale), it can be displayed as FirstName (PreferredName) LastName - IDNumber.

Is there any way to customize the display of a lookup list to change based on the the value of a particular column?

So:
If (PreferredName != "")
FirstName (PreferredName) LastName - IDNumber.

If (PreferredName == "")
FirstName LastName - IDNumber.