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.