Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data from 2 tables side by side

Status
Not open for further replies.

Aerowolf

Programmer
Nov 6, 2002
64
I have a products table, a plating table and a process table. There can be several entries in the plating and process tables for each part in the products table. All three tables are linked via ProductID.

On my report (which is sorted and grouped by ProductID), I am displaying the ProductID, ProductName, and ProductDescription in the ProductID group header. In the details section I want to be able to list the process entries on the left side and the plating entries on the right side for the related part. I want to have one part per page which is why it is grouped by ProductID.

How do I do this?

Thanks

Edwin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top