I have been using FileMaker Pro 9 (running on Mac OS 10.6.8) for several years to create a community history archive. After not having opened the file for a few months, I did so this week only to discover that one of the text fields in each of about 200 of the 1,000+ records has been replaced with text that had existed in the same field in only one of the records.
My questions are:
Has the file been corrupted?
Is there anything I can do to reverse this so that the original text in each of those records is restored?
How can I ensure that this problem will not continue to effect/infect other records?
Many thanks for any recommendations.