General information
Category:
Reports & Report designer
Title:
Multi-Table Reporting
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).
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only