nuBuilder Forum

Hi All,
I'm searching a solution for following problem:
I have the table "kontakt" with fields like kon_surname and kon_firstname.
The record is used as a lookup in another table "order". But in the Customer Field of "order" I want to show the information of kon_firstname + kon_surname.
So far I couldn't find a solution how to get a value combined of 2 fields visible there.
Would be great if someone could help me.

Thanks a lot!

BR, Oli

Hi Oli,

You can use CONCAT() to combine multiple strings that are displayed in the description field of a lookup object.

Thank you! Perfect and easy solution !!