Multiple text entries in a field need to be deleted
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?