>****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

Pull all the needed data into a single cursor, then place multiple fields in the detail band and control printing using the Print When option of each report object.