Questiona about printing with associated fields

[Kenneth Brody]

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