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
Welcome to the nuBuilder Forums!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
how to create a value combined of 2 (or more) field values
-
kev1n
- nuBuilder Team
- Posts: 4565
- Joined: Sun Oct 14, 2018 6:43 pm
- Has thanked: 76 times
- Been thanked: 529 times
- Contact:
Re: how to create a value combined of 2 (or more) field valu
Hi Oli,
You can use CONCAT() to combine multiple strings that are displayed in the description field of a lookup object.
You can use CONCAT() to combine multiple strings that are displayed in the description field of a lookup object.
You do not have the required permissions to view the files attached to this post.
Re: how to create a value combined of 2 (or more) field valu
Thank you! Perfect and easy solution !!