Managing Recordset Columns

Recordset columns can be created, if two tables are related.

Recordset columns are columns in a master table that act as the reference to the set of the detail records. For example, you have a Project record and a list of Tasks in the details table. The recordset column will contain the IDs of those Tasks from the details.

The simplest way to add a recordset column to the related table is as follows:

1. Click the Setup link in the top right corner of the window.

2. Select the table you need.

3. From the setup menu, select Tables > Manage relations.

4. In the Selections section, click the New Recordset button and select the necessary relation in the window that opens next.

The Recordset column form will be displayed:

Fill in the displayed form to create a Recordset column.