I am creating a customer database for our marketing dept, and I would like to know how to make 2 fields and combine into a 3rd as one field. Here is the sceniro:

First - Seperate Field

Middle - Seperate Field

Last - Seperate Field

First & Last - Serperate Field

I would like to know how to make the last by inputting the First, Last so it will auto fill into the First & Last field? Thanks

If you looked at the Operators in the Define Fields, Calculation Edit Box, you will find [color:red]& sign. If you look up the operators in the Online Help (When FileMaker is opened), you will see the [color:red]& is described as Text Operator, and is used to concatenate Fields.

What this means in plain English, you are able to combine Text fields like this:

First - Seperate Field

Middle - Seperate Field

Last - Seperate Field

New Field (Calculation, Text Result) =

First [color:red]& Middle [color:red]& Last

you can make it more readable by adding spaces like this.

First [color:red]& " " & Middle [color:red]& " " & Last

HTH

Lee

Edited May 7, 200817 yr by Guest

Thanks

Neil