Does anyone know if it is possible to create a lookup column in SharePoint 2010 that shows multiple column values? For example, I can get the lookup column to work and show entries from a list in my site, but i want it to show another column from that list as well. I want it to show customer code AND the customer name that relates to that code.... Please see the image for an example.
All of the customer information resides in list.