****Using FoxPro 2.6****
I am rewriting a Purchase Order system for my company that has the following data sources:
PurchOrd - the parent PO table
->Vendor - related Vendor information(name,address,etc) 1 to 1
->Deparment - related Department information(name,suite,etc) 1 to 1
->Funding - related funding information(fund,account,etc) 1 to many
->LineItem - related line items(item,quantity,price) 1 to many

The problem I have is with creating the Report to print the PO. The format of the printout cannot be changed and it starts with the Department Info, then lists the Funding details, then the Vendor information and finally lists the line item details. I cannot come with a way to do both the funding details and the line item details on one page. ANy suggestions?

Shane