AnsweredAssumed Answered

Multiple text entries in a field need to be deleted

Question asked by ScottBinder on Dec 27, 2013
Latest reply on Dec 27, 2013 by philmodjunk

Title

Multiple text entries in a field need to be deleted

Post

     I have FM Pro 12 and one of the fields where users can enter data saves all prior data entries.  So therefore when a user wants to enter data in that field, over 250 different entries are "saved" as choices that can be used.  If someone in the past has misspelled a word and entered it, it's now "saved" as a choice for future entries.  This is a problem.

     This field is in use with 3,000 current records.  I want to do two things:

     1.  Clean up and delete as a "saved" choice all the incorrect prior entries.

     2.  When I do the above, ensure that all the correct entries are not deleted from the record.

     Is there a simple way to accomplish this. 

     I am not a FP expert by any means.  Just a simple user of the database.  Is there an easy fix for this?

Outcomes