AnsweredAssumed Answered

Appending a field in fmp 12

Question asked by RandyRiggs_1 on Aug 20, 2013
Latest reply on Aug 20, 2013 by RandyRiggs_1

Title

Appending a field in fmp 12

Post

     I have a fmp database I created in fmp 10 and have been using for 5 years running my business. I recently upgraded everything to fmp12 including my new Mac mini running fmp server advanced 12.

     one field in my parts master file needs changed. Currently, I have about 500 records out of 3500 with the following designation:

      

     YDS200TCPSG1A. 

     The "Y" at the front designates this record to be a repair. The actual part number starts with the "DS200......"

     I want to change all these records as follows:

     remove the "Y" and add "-REP" at the end of each part number.

      

     i have been unable to do this so far. Any ideas would be appreciated.

     randy

      

      

Outcomes