Questiona about printing with associated fields

[Boaz Bezborodko]

Kenneth Brody wrote:

>Quoting Boaz Bezborodko (Tue, 19 Sep 2006 14:19:03 -0400):
>
>  
>
>>I'm dealing with a database that was designed quite a while ago by
>>someone else.  They have one file that holds the details of cash
>>receipts for each individual check that includes associated fields for
>>the invoices paid (call it A1) and another set of associated fields for
>>the short payments on the check (call it A7).  I want to print out,
>>side-by-side, all the invoices paid and all the short payments generated
>>line by line.  I also have to put in some additional information that
>>has to be looked up from other files.
>>
>>The long way to do this is to put each of the actual field numbers on
>>the form and use an array for the lookup information.  What I wanted to
>>know is whether there is a cheat around this where I could loop through
>>@AF and then use the PRINT command to get that particular associated
>>field printed on the data line?
>>    
>>
>[...]
>
>Add a minor sort on A1 (or A7 or any of the A group) and place A1 and
>A7 on the report.  They will now refer to the corresponding entry in
>the record.
>
>--
>KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
>http://www.hvcomputer.com
>http://www.fileProPlus.com
>  
>
But what if A1 has is blank and A7 has an entry.  This might happen if a
check pays off one invoice, but references 3 deductions.  Will only the
A1 with an entry print leaving the other A7s out of the report?

Boaz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20060919/bd31fc21/attachment.html