One way: Create a select statement to gather the first set of data and add a dummy variable called 'PART' and provide a default value of '1'. Create a second select statement from the second set of data and create the same variable called 'PART' and provide a default value of '2'. Union the two select statements and sort first by your report criteria (customer id?) and then by part. In your detail fields use statements like IIF(PART='1',...) or IIF(PART='2'... Add GROUPS to the report on PART within CUSTOMER. Should print in the detail section all the PART='1' records first, then all the Part='2' records. In the part footer you can put separator lines, spaces, etc. Do your total in the CUSTOMER footer.

HTH

Mike

>Hi All!
>
>I need to figure out how to create a Foxpro report, from the report designer, that pulls data from two or more tables. The client wants something like this:
>________________________________________________________________
>Customer: XXXXX Home Phone: (123) 123-4567
>Address: XXXXX Work Phone: (123) 123-7654 Ext. 123
> XXXXX
>________________________________________________________________
>Manufacturer Style Code Quantity
>Manufacturer Style Code Quantity
>Manufacturer Style Code Quantity
>Manufacturer Style Code Quantity
>________________________________________________________________
>Extra Description Extra Quantity
>Extra Description Extra Quantity
>Extra Description Extra Quantity
>________________________________________________________________
>Total Units Total Cost
>
>The manufacturer info is from an sales file and is each line item sold. The extras come from a labor table for extra cost options. Both are related to the customer by a 'deal' number.
>I can get either the manfacturer stuff, or the extra stuff, but not both on the same page.
>
>TIA!
>Tom.
>
>I'm using Foxpro 6.0 on an NT network with the various defined printers for any of the workstations (Windows 95).