How to calc FirstName and Surname to = Name

[Bapak]

Have Fields FirstName and Surname.+ Name

How to calc FirstName and Surname to = Name

[doughemi]

If you mean that FirstName contains "John" and Surname contains "Smith" and you want Name to contain "John Smith":

Name = FirstName & " " & Surname

If you mean something else, please give an example.

[Bapak]

Thanks.. that is what I mean...and this is my entry:

Name = FirstName & " " & Surname

But sorry to say, it is not happening.

Please see attachment.

[IdealData]

No attachment.

[doughemi]

Attached files must be zipped first.

[Ron Cates]

If this is a calculation field then the formula you would enter in the field calculation dialogue would just be;

FirstName & " " & Surname

not

Name = FirstName & " " & Surname

[Lee Smith]

I read "Name" as the name of the field, and not part of the defined calculation.

Name (calculation, text) =

FirstName & " " & Surname

BTW, FileMaker would reject [Name = FirstName & " " & Surname] as a calculation

I would change the names to make it clearer to something like

NameFull (calculation, text) =

NameFirst & " " & NameLast

hth,

Lee

[Bapak]

I read "Name" as the name of the field, and not part of the defined calculation.

Name (calculation, text) =

FirstName & " " & Surname

BTW, FileMaker would reject [Name = FirstName & " " & Surname] as a calculation

I would change the names to make it clearer to something like

NameFull (calculation, text) =

NameFirst & " " & NameLast

hth,

Lee

I read "Name" as the name of the field, and not part of the defined calculation.

Name (calculation, text) =

FirstName & " " & Surname

BTW, FileMaker would reject [Name = FirstName & " " & Surname] as a calculation

I would change the names to make it clearer to something like

NameFull (calculation, text) =

NameFirst & " " & NameLast

hth,

Lee

Tried that Lee but...

See attachments.

[efen]

You are making this more complicated than it needs to be - see Ron Cates' answer above - all you need is

NameFirst & " " & NameLast

[Bapak]

You are making this more complicated than it needs to be - see Ron Cates' answer above - all you need is

NameFirst & " " & NameLast

You are so right... all done and working. Thanks all.