Article View: comp.sys.mac.databases
Article #638Re: Question on Lookup feature in FM Pro
From: Andrew Dent
Date: Thu, 21 Jan 1993 16:34
Date: Thu, 21 Jan 1993 16:34
24 lines
1252 bytes
1252 bytes
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.
Andy Dent (A.D. Software - Mac & VAX programming)
94 Bermuda Dve, BALLAJURA Western Australia 6066
Phone/Fax: 09 249 2719 (local) +619 249 2719 (International)
Internet: dent@DIALix.oz.au Compuserve: 100033,3241
Technical Details
Message-ID:
<1jmjav$263@DIALix.oz.au>Path:
arc1-ca.pugleaf.net!sparky!uunet!munnari.oz.au!uniwa!DIALix!dentReferences:
<1993Jan18.174759.201504@bmug.org>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!munnari.oz.au!uniwa!DIALix!dent From: dent@DIALix.oz.au (Andrew Dent) Newsgroups: comp.sys.mac.databases Subject: Re: Question on Lookup feature in FM Pro Date: 22 Jan 1993 00:34:39 +0800 Organization: DIALix Services, Perth, Western Australia Lines: 25 Message-ID: <1jmjav$263@DIALix.oz.au> References: <1993Jan18.174759.201504@bmug.org> NNTP-Posting-Host: localhost.dialix.oz.au X-Newsreader: NN version 6.4.19 #1