Associated fields question (Jeff Harrison)

[Jeff Harrison]

--- Boaz Bezborodko <boaz at mirrotek.com> wrote:
[snip]
> >  
> >
> I have a few questions regarding associated fields
> in a report.
> 
> What happens if the associated field you're trying
> to determine is not
> the primary sort? 
> 
> What if there are two different associated fields in
> the sort? 
> 
> Is there a way to determine which instance is being
> dealt with?
> 
> Thanks in advance.
> 
> Boaz


Good questions.  

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

#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.  For each a0
value that was the same, I could see that the
secondary sort was applied properly.

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

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