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

We had some programs which needed to list two or more 1-to-many relations, and the solution we used was writing functions which returned a completely formatted string (i.e., including carriage returns and line feeds). With this kind of solution, you print the detail records from one solution and you print the other relations using the functions.