I have three fields. DATE, NAME, TICKET NO. I need to concate data from all these 3 fields into one field. Can someone please help!
Date & Name & TIcket NO
But are you sure that you really need to? In many situations, you can use merge fields to create on your layout what looks like concatenated data but what is really simply a set of merge fields in the same layout text object.
http://www.filemakermagazine.com/articles/my-favorite-text-calculationsMy Favorite Text Calculations
http://www.filemakerprogurus.com/label-fields-smart-concatenation/Label fields — Smart concatenation
http://help.filemaker.com/app/answers/detail/a_id/4551Combining two or more fields into a single field- concatenations explained
How do you combine two or more fields into a single field?
http://help.filemaker.com/app/answers/detail/a_id/5038Concatenating a Quote Mark in a Calculation Formula
Retrieving data ...