Combinging 2 fields

[Arcanoi]

I want a field to look up two values a first and last name and have a full name value with a space between the two I know this is possible with a merge field in the layout, but that won't let me do a proper layout, is there any way to do this?

[Fitch]

I'm not sure what you mean about not doing a "proper layout," but the calculation for that would simply be:

FirstName & " " & LastName

Inside the quotes is a space. Your field names may vary.

[Arcanoi]

I take it that & and "and" are diffrent in FM I was trying to do it with "and" and of course it gave me boolean thanks for the help

[Lee Smith]

Hi Arcanoi,

Open your online Help in FileMaker and type in Operators.

You will see four type listed.

In the Text you will find &

In the Logical you will find AND

HTH

Lee