two fields in a lookup?

[merlin777]

i've managed to use the lookup wizard to show me two fields in the drop down list, first name and last name, but when i select a record I can only see the first name in the cell, not both.

Is there a way to display them both together?

 

[pr2-eugin]

Create a third column that has the concatenated field. This is the simple and straight forward way I can think of.