1 Reply Latest reply on Jan 12, 2010 9:18 AM by mrvodka

    Combining 2 Fields



      Combining 2 Fields


      I am using FileMaker Pro 10 on Mac OSX Snow Leopard.  This should be easy....I have a large data file and need to combine 2 fields into one and alter their case.  They are first name and last name and I need them to be in one field in that order.  I was using a script and tried using functions LeftWord, Replace and Substitute functions.  Nothing worked.  This cannot be this difficult....


      Thanks for your help.