What's the trick

[Gambler]

Dumb Question -- sorry, but.....

I'm trying to join (concatenate) two fmp fields in the same file (e.g. FirstName and Last Name) into a single field FullName (virtual field calculate or look up evey time).

The layout field order is

FirstName

LastName

FullName

In define fields under calculate, I use (FirstName & " " & LastName) to generate FullName.

I cannot get the LastName to display. I get FirstName and the space, but no LastName.

What the $%#@&% am I doing wrong here?: PLEASEEEEEEEEEEEEEE

[SteveB]

Are you sure that the field is big enough to display both names? FM will not display partial words. What you're doing sseems fine.

[goldraven]

You should also double check to be sure all three fields are defined as text fields.