Report problem

[Arnone, Anthony]

Good Afternoon all,

	I am having a problem that I can't seem to figure out how to get
around. Hopefully I wont confuse anybody with my explanation of the problem.
I am using version 8.19 on an HP3000 running MPE/iX.
	I have 2 tables, one is an accounts payable table and one is and
accounts receivable table. Both tables contain a field called
ClientJobNumber which is the primary key.The report currently prompts for
one ClientJobNumber then I access the accounts payable table then write it
to a disc file then access the accounts receivable info then append it to
the same disc file. This works fine because it is just one ClientJobNumber
that I am grabbing and then simply writing the data to the disc file. But
the user now wants the report to grab all ClientJobNumbers and create the
same report by showing a ClientJobNumber with the A/P info then the A/R info
then showing the next ClientJobNumber and so on, all in the same disc file.
The problem that I am having is because the AP data and the AR data are
different how can I create the disc file looking the same way when I am
getting the data at different times. I hope that I didn't confuse anyone
with this, if you have any questions please let me know.

	Also one way that I tried was to create a subfile of both tables but
then I have no way of putting the AR info after I total the AP info.

				Anthony