A field with multiple fields in it.

[Steven1337]

I basically need an address label.

I have the fields: firstName, lastName, address, city, state, zip

Instead of individually copying each field to an email i want to create a field that has all those fields already in it combined.

Is this possible through a calculation? i tried a merge field but for some horrible reason you cannot select its contents. This would be of great help.

[efen]

Create a calculation field defined along the lines of

firstname & " " & lastname "¶" &

Case (not IsEmpty(address line1) & "¶"; "") &

Case (not IsEmpty(address line2) & "¶"; "") &

Case (not IsEmpty(address line3) & "¶"; "") &

[etc]

if you want the address on separate lines. Use comma and space instead of the pilcrow if you want the lines to run on

[Steven1337]

Thanks a lot that works great. I just need to get more familiar with the way filemaker "language" works.