Working with multi-record objects

A multi-record object displays several table records at a time by using a field layout that repeats a specified number of times horizontally and vertically on the page. When you add a multi-record object to a form or report, a container is created containing a master record object and several blank records. When the form or report is run, the multi-record object displays data from the table fields that you specify. Multi-record objects are useful for creating items such as mailing labels. Each label consists of a group of fields, for example name, address, and city, in a layout. The fields are repeated for every record in the table.

In this section, you'll learn about

  placing multi-record objects on forms or reports
  
  adding and removing fields in multi-record objects
  
  specifying the layout of a multi-record object
  
  modifying record display in a multi-record object
  
Placing multi-record objects on forms or reports

You can place a multi-record object on any form or report design. A multi-record object is a container for record objects. Each record in the multi-record object contains a group of fields that you choose. For more information about adding fields to a multi-record object, see "Adding and removing fields to multi-record objects."

To place a multi-record object on a form or report

1	Click Insert  Multi-record.

2	Click the multi-record object and drag it to a new position in the design window.

If you need to resize the multi-record object, point to a selection handle and drag the object in the design window.

Note

  For more information about sizing and shaping objects, see "Sizing and shaping design objects."
  
Tip

  You can also insert a multi-record object by clicking the Multi-record tool on the toolbar.
  
Adding and removing fields in multi-record objects

You can define which fields are displayed in each record of a multi-record object. For example, if you use a multi-record object to create a mailing label, each record in the object represents one label. Each label consists of a group of fields that you add to the record; for example name, address, and city. The fields are repeated for every record in the table. You can remove the fields that you add to a record. You can only add fields from one table; you cannot add fields from multiple tables.

To add a field to a multi-record object

1	Right-click a multi-record object, and click Define record.

2	In the table's list box, double-click the field you want to add to the Included fields list.

You can also	

Add multiple fields to the Included fields list	Hold down CTRL, and click the fields in the table's list box. Double-click the last field you want to add.

Change the order in which fields display in the multi-record object	In the Included fields area, click the up or down arrows.

Note

  If you make the record object too small, fields are automatically removed from the Included fields list in the Define multi-record object dialog box to make the record fit the container. For more information about resizing, see "To resize records in a multi-record object."
  
To remove a field from a multi-record object

1	Right-click a multi-record object, and click Define record.

2	In the table's list box, double-click the field you want to remove from the Included fields list.

3	Click Remove field.

Specifying the layout of a multi-record object

You can specify how many records to repeat across and down in a multi-record object. Each record in a multi-record object consists of a group of fields, which are repeated for every record in the table. If you add multiple fields to a multi-record object, you can specify whether you want the fields to be displayed in columns or rows, and whether you want field labels displayed within the record.

To specify the record layout of a multi-record object

1	Right-click a multi-record object, and click Properties.

2	Click the Record layout tab.

3	In the Number boxes, specify the number of records to repeat across and down the page.

4	In the Separation boxes, specify the vertical and horizontal separation between the records.

5	To specify the order in which the records are filled, enable one of the following options:

  Top-down, then left-right - displays records in order from top to bottom, with any additional columns displaying to the right
  
  Left-right, then top down - displays records in order from left to right, with any additional rows displaying beneath the existing rows
  
To specify the field layout of a multi-record object

1	Right-click a multi-record object, and click Field layout.

2	Enable one of the following options:

  By column - displays fields by column within the record
  
  By row - displays fields by rows within the record
  
To display field labels within a multi-record object

1	Right-click a multi-record object, and click Field layout.

2	Enable the Label fields check box.

Modifying record display in a multi-record object

You can modify the display of a multi-record object in a number of ways. You can resize the records. You can also expand or contract individual records in a multi-record object when you print or preview reports, so that the multi-record object does not display the records in a fixed-size grid.

To resize records in a multi-record object

1	Click the master record region of a multi-record object to select it.

2	Drag any of its selection handles.

Paradox resizes the gray repeating regions along with the master record region.

To expand or contract records in a multi-record object

1	Right-click a multi-record object, and click Properties.

2	Click the Record layout tab.

3	Enable the Top-down then left-right option.

If the multi-record object is in a report, enable the Variable height (columnar) check box.

Note

  The record object inside the multi-record object is a container for the records. If you make the record object too small, Paradox eliminates fields to make the record fit the container.
  



