Associated fields question (Jeff Harrison)

Boaz Bezborodko boaz at mirrotek.com
Thu Mar 30 09:37:06 PST 2006


Jeff Harrison wrote:

>--- 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.
>  
>
In #3 is there a way to tell which instance of the secondary sort is
being dealt with?

Thanks again,
Boaz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060330/637707b3/attachment.html


More information about the Filepro-list mailing list