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

Just struggled with this myself. We solved it by using UDF's that returned a formatted string.

There's a tool called GENREPOX that allows for multiple detail bands. Check the files section.

paul