Hi all

I have a field with a value list attached, displayed as a checkbox field

The options are something like:

Plumber
Apprentice Plumber
Master Plumber
Electrician
Apprentice Electrician
Master Electrician
Builder
Apprentice Builder
Master Builder

Now we need to do a find on this field

If I check:
Electrician
Master Electrician

The aim is to find records which have both options ticked

But it is finding records where only 1 is ticked and because Master
Electrician is ticked it is also finding any records with the Word 'Master'
so am ending up with all sorts of results.

I will add a script in to manipulate the search using a text box calculated
by the options ticked, but the question is what to add. I think a
combination of "" = =Just not sure in what format.

If I tick Electrician, it should just find records with Electrician ticked
(shouldn't matter if other boxes are ticked or not)
If I tick Electrician and Master Electrician it should records with both
ticked (again shouldn't matter what other boxes are ticked)

If the value list was made up of 1 word options it wouldn't be an issue.
Obviously FM does an AND search anyway when it is all part of 1 search
request but the issue is when searching for an option, because it is doing a
search on the actual words, Master Builder would bring up search results
including builder, master plumber, master electrician etc.

Anyone know the best format to but the search into?

Many thanks
Ed


#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>