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