Newbies Neil Coates Posted May 7, 2008 Newbies Share Posted May 7, 2008 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 Link to comment Share on other sites More sharing options...
Lee Smith Posted May 7, 2008 Share Posted May 7, 2008 (edited) 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, 2008 by Guest Link to comment Share on other sites More sharing options...
Newbies Neil Coates Posted May 7, 2008 Author Newbies Share Posted May 7, 2008 Thanks Neil Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5825 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now