We have had a problem searching our database. We have multiple fields for names, and so, for example, we searched for 'Joe Bloggs', or 'Joe', or 'Bloggs', and it would not find his record. If his name was in a different name field, it would.
I checked the settings and changed all the name fields index options to 'index all'.
It then started to work....for some records.
It still wouldn't find 'Joe Bloggs'. I went to Joe Bloggs record manually, and I edited this record. I deleted his name and retyped it in the same field. When I searched again, it found it.
Why did it not find it until I had edited the record? If this is the case it will cause major problems, because my searching will not work unless I edit nearly every record on my database.
I also have an issue searching for email addresses. I can search the email field for an email address with no problem, but it will not let me search 'all fields' for an email address because of illegal characters (the '@', I assume).
This is all making it very difficult to use our database.