<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Kenneth Brody wrote:
<blockquote
cite="mid20060919144014.y90k4ws8wwok8w0c@webmail.spamcop.net"
type="cite">
<pre wrap="">Quoting Boaz Bezborodko (Tue, 19 Sep 2006 14:19:03 -0400):
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->[...]
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: <a class="moz-txt-link-rfc2396E" href="mailto:g8ymh8uf001@sneakemail.com"><g8ymh8uf001@sneakemail.com></a>
<a class="moz-txt-link-freetext" href="http://www.hvcomputer.com">http://www.hvcomputer.com</a>
<a class="moz-txt-link-freetext" href="http://www.fileProPlus.com">http://www.fileProPlus.com</a>
</pre>
</blockquote>
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?<br>
<br>
Boaz<br>
</body>
</html>