Associated fields question (Jeff Harrison)

[Kenneth Brody]

Quoting Jeff Harrison (Thu, 30 Mar 2006 09:24:00 -0800 (PST)):
[...]
> #1  I tried a simple test and it appears that the
> record is not included multiple times in the output
> unless the associated field is the primary sort.

What sort of test did you run?

If you sort, for example, on fields 1 and A1, then the records will
be included once for each non-empty A1 field in the record.  (Or once
if all A1's are empty.)

> #2  I tried a simple test using two associated fields
> a0) and a1) with three instances (rows) in the data
> for each record.  I used a0 as the primary sort and a1
> as the secondary sort.  When I ran the report each
> record appeared 3 times in the output - which is the
> behaviour that I was hoping for - and it was
> automatically sorted by the a0) value.

And the A1 value as the secondary sort.  (Just as sorting by last
name and first name will sort with both.)

> For each a0
> value that was the same, I could see that the
> secondary sort was applied properly.

Because A0 and A1 are part of the same group, this is true.  If
you were to sort on A0 and B0, then you would get all combinations
of the two groups.

> #3  Yes, @af tells you the proper instance that you
> are dealing with.

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