Re: FMP question
Re: FMP question
- Subject: Re: FMP question
- From: Shane Stanley <email@hidden>
- Date: Fri, 03 Nov 2000 13:37:37 +1100
On 3/11/00 1:17 PM +1000, Paul Berkowitz, email@hidden, wrote:
>
? Not really. I don't care if there's more than one (i.e. previous
>
duplicates), it will simply prevent a new one being made. The cellValues
>
being checked are all the significant non-calculated ones. If applied
>
consistently from now on, there never will be duplicates.
>
>
Or am I missing something?
Yes. The problem is that the search may throw up a false match -- "Johnson"
for "John", let's say. The check "if n does not equal {b, f, c, d, e} then"
will pick this up as a false match, and then you will add a new record --
but what if there was a second record already there that was also a match?
Better to get all matches, and loop through them.
--
Shane Stanley, email@hidden