Basic Find Doesn't Find in One Field

[jeffamm]

Hi, I've been using FM8 for awhile so I'm not a newbie, but I am perplexed. I have a text field that is indexed but searches on this field (or imports using the matching fields) do not find data that is in this field. I can select the data in the field, copy it, then run the find and paste the exact data just copied, and it won't find it. Other fields seem to find just fine. Any ideas?

[mr_vodka]

Have you tried re-indexing the field?

[jeffamm]

Mr Vodka, I thought of that but haven't been able to find out how to do a reindex - how do you do it?

[Lee Smith]

Go into Define Database , and select the field involved. Select Options for the field, Select Storage, and deselect the "Automatically create indexes if needed."

Click okay your way out to the Browse Level.

Then reverse the process to reset the indexing.

Note: if this is a calculation field, the calculation edit box will have the Select Storage button.

HTH

Lee