Associated fields in selection table

[Kenneth Brody]

Quoting Barry Wiseman (Fri, 26 May 2006 12:52:25 -0400 (EDT)):

> Linux rclerk 5.0.14R4.
[...]
> The B) fields contain arbitrary text.  I am trying to compose selection
> tables that will find combinations of keywords, for example:
>
>     þ  B) þ B) Memo Description     co þ   emer                þ
>     þ  B) þ B) Memo Description     co þ   round               þ
>
> I find that this will only select records where both strings occur in
> the *same* field; it will not search all five fields for each string.
>
> I sure didn't think this was the expected behavior.

It is.

> How can I do multiple keyword selection against this group of fields
> using the field association?

Place the statments in separate groups.  If you refer to the same
associated field group letter within a single selection set group,
it means that a single instance of the group must satisfy the
condition.

Consider, for example, searching for someone with "a1) product code"
equal to "fp56" and "a2) quantity" greater than "10".  (Meaning, of
course, that the "fp56" quantity was greater than 10.)

[...]

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com