Odd Find Results

[SteveB]

I have a field called Profession (text, indexed). I do a find on 'Buyer - Is My Client' and in addition to turning up records having this Profession type, I also turn up records having 'Buyer - Is Not My Client'.

It looks like the field matching goes only as far as the word 'Is'. This shouldn't happen. Anyone have an explanation?

Win XP FM v8 Advanced.

Steve

[Raybaudi]

Hi

the search must be done with a doble =, so you have to search for:

==Buyer - Is My Client

otherwise FM will find also 'Buyer - IS my BEST client' because the words:

Buyer,-,Is,My,Client are in both the records.

[stanley]

Exactly. If you change the two options to:

Buyer - Is My Client

Buyer - Not My Client

Then you won't have the problem.

-Stanley

[comment]

Actually, there are two facts here, so two fields would be more appropriate.