"Dual criteria indexes" (was Re: What should fp 6.0 look like?)

[Howie]

From: "Kenneth Brody" <kenbrody at bestweb.net>
To: "tom heine" <tch at aljex.com>
Cc: <filepro-list at lists.celestial.com>
Sent: Friday, October 22, 2004 1:37 PM
Subject: "Dual criteria indexes" (was Re: What should fp 6.0 look like?)


| tom heine wrote:
| [...]
| > associated fields working in dual criteria index's
| [...]
|
| What is a "dual criteria index", and what "doesn't work" with them with
| associated fields?
|


It hasn't worked in quite a while.

I assumed you and fptech were aware of it.

Example: You have a records with a set of state fields where {S1) PU State"
are up to 10 states that the company picks up from and "S2) Delv State" are
10 states the company delivers to.

If you build an index on s1) as the first criteria and s2) as the second and
try to use it to find a company that picks up in say NJ and delivers to CA
nothing will be returned, even though many records contain the requested
data.

I understand that the example seems flawed and it should return any record
that contains NJ in any of the S1) fields and CA in any of the S2) fields
but that's exactly what we want - only nothing is returned.

Howie