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

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.

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