Associated fields question (Jeff Harrison)

[Jeff Harrison]

--- Kenneth Brody <kenbrody at bestweb.net> wrote:

> 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.)

Yes, I was mistaken.  I accidentally used my A1) group
instead of my A0 group for this test.  The A1) group
only had two values filled in, so it was only selected
twice.

> 
> > #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.

Ah, That is good to know.


Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and imports.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com