🚀 go-pugleaf

In article <1jmjav$263@DIALix.oz.au>, dent@DIALix.oz.au (Andrew Dent)
wrote:
> 
> The biggest problem with lookups in FM Pro is that they are UNRELIABLE!!!!!
> 
> This (now that I've got your attention) stems from the matching of words.
> 
> eg: if file schools contains (IN ORDER)
>   St Columba's Primary School
>   St Columba's School
> 
> 
> then a lookup to schools of "St Columba's School" will return the FIRST
> of the entries.
> 
> So will a lookup like "School St".
> 
> The matching is to the first entry matching ALL the WORDS in the lookup
> field.
> 
> Be VERY careful about the implications of this one - I was hoping FM v2 would
> have a fix - it doesn't.

There really isn't anything to fix; it is a matter of interpretation.  When
you find "School St." you are looking for all records that contain "School"
and "St." in that field; you are not looking for the string "School St." in
the field.  It works as designed.

Now, whether that is the optimal design is another consideration.  One
possibility is to enhance the application by adding a metacharacter to
represent a space in a search.  I don't know whether the FileMaker team is
considering this, but I do know that some of them read this newsgroup.

+---------------------------------------------------------------------+
|                         Boycott Colorado                            |
|     These are my opinions, and not necessarily any one else's.      |
+---------------------------------------------------------------------+