Questiona about printing with associated fields
Boaz Bezborodko
boaz at mirrotek.com
Tue Sep 19 11:19:03 PDT 2006
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?
IOW, if I use the fields A1 and A7 in the output format does using the
PRINT command output those in the report? If it does can I then change
@AF, generate a PRINT command and get another output of the new line?
And, finally, will =A1 and =A7 properly total in the subtotal lines or
do I have to do this myself in a global variable?
Thanks,
Boaz
More information about the Filepro-list
mailing list