Joining two fields

siimsand

Hello!

I have a pretty simple question. If I have 3 fields - First name, Last name and Full name. Then how do I join First name and Last name for Full name to appear?
I imagine it's something like:

First Name - OnValidate()
xRec."Full Name" := "First Name" + ' ' + "Last Name" ...

But I can't quite get the code right. Should I use a special function for this or am I missing something super easy?


Thanks in advance.

RockWithNAV

Why are you using xRec??

"Full Name" := "First Name" + ' ' + "Last Name"

Is this code not ding your Job?

Write this code on Last Name Validate Trigger too

"Full Name" := "First Name" + ' ' + "Last Name"

RockWithNAV

Why are you using xRec??

"Full Name" := "First Name" + ' ' + "Last Name"

Is this code not ding your Job?

Write this code on Last Name Validate Trigger too

"Full Name" := "First Name" + ' ' + "Last Name"

nick_robbo

Just create a function called something like GetFullName, which returns text....
Call this in the OnValidate trigger of each Name field.

So it would look something like this...

"Full Name" := GetFullName;

And the function would look like this...

GetFullName() : Text[100]
IF "Middle Name" = '' THEN
  EXIT("First Name" + ' ' + "Last Name");

EXIT("First Name" + ' ' + "Middle Name" + ' ' + "Last Name");