One-To-Many Report Wizard

Article
11/14/2006

The One-To-Many Report wizard creates a report that groups records from a parent table with records from a child table, for example, names and address from a Customer table and amounts and discounts from an Orders table. The wizard prompts you with simple questions as you go through a brief series of steps, in which you specify the table and fields that you want to use to create controls on your report.

To access the One-To-Many Report wizard

From the Tools menu, choose Wizards, and then click Report.
In the Wizard Selection dialog box, choose One-To-Many Report Wizard.

Step 1 - Select Parent Table Fields

In this step, you choose a free table or table or view from a database that will provide the controlling fields data presented in your report. This specifies which field of the parent or controlling table determines the records selected in the child or controlled table.

To select the fields for your report

Use the Databases and Tables controls to locate and select the table you want to use.
In the Available fields window, select one or more fields you want to use from the selected table, and use the arrow buttons to move them to the Selected fields window.

You can select fields from a single table or view only.

Step 2 - Select Child Table Fields

In this step, you choose the fields from the related table. This step determines which fields from a child or controlled table are displayed on the form. For example, the parent table might hold only customer names, ID numbers, and addresses, and the child table might hold orders information, such as ID numbers, amount, date, discount, and so on. One customer might have many orders.

You can select fields from a single child table or view only.

Step 3 – Relate Tables

In this step, you specify from the fields list how the parent and child tables are related. In the example from step 2, both tables contain the customer ID field, so that is one way to relate them. There might be other ways depending on the available fields and what you want to report.

Step 4 – Sort Records

In this step, you can select in the parent table the fields in the order that you would like to sort the records. For example, if you are using two fields and have a first name field and a last name field, then you could choose to sort on first name+last name (such as PaulWilson) or on last name+first name (such as WilsonPaul). How you sort is determined by the order in which you selected those fields.

If your table already has one or more indexes, you can select the index tag, which is listed below the fields, separated by a line, in the Available fields window.

Step 5 - Choose Report Style

In this step, you can choose the basic format of your form from the styles built into the wizard. When you click any of the styles, the wizard updates the graphic in the magnifying glass as an example of the style.

The Summary options button makes it possible for you to specify whether your report will include one or more calculations, such as sum or average, on available fields.

You also can choose whether your report will display or print in portrait or landscape orientation.

Step 6 - Finish

In this step, you can choose how and when to use the report.

Save report for later use
Makes it possible for you to save the report as a file, which you can open later.
Save report and modify in the Report Designer
Saves the report as a file and then opens it in the Report designer, so you can make modifications to it.
Save and print report
Saves the report as a file and then immediately prints it.

If you select Use display settings stored in the database, then your report uses information from the database.

If the number of fields you selected cannot fit on a single line within the width of your report, the fields will wrap to the following line. If you do not want the fields to wrap, clear the Wrap fields that do not fit check box. Click the Preview button to view the report without exiting the wizard.

After you save the report, you can open and modify it like any other report in the Report designer.

Share via