The report designed in the Walkthrough: Designing a Simple Report was very simple: it was based on one table which it ran through and printed the records. In this walkthrough, you will learn how to design reports that are based on more than one table.

The sample report that you will create uses two tables: the Customer table and the Sales Line table, which contains not-yet-posted sales orders that contain information about the actual items that have been ordered by the customers. There is a one-to-many relationship between the two tables—while one customer can have many items on order, each sales line can only refer to one customer.

Expand imagePrerequisites

Expand imageDefining the Data Model

Expand imageDesigning the Sections

Expand imageSee Also