Underview Fields

Underview fields are shown on a record view page beneath the other fields in a record, as a table. They show fields from a linked record in another database, for example the Persons database.

When you choose the Underview Fields option in the Configurator, then select a database, a screen as shown in the following Persons database examples, will appear:

Two pages are shown for each database, the first one is to configure Underview fields for  Archive record types, the second is to configure Underview fields for Museum record types.

Underview Fields can be added, removed and their order changed in exactly the same way as Record Fields, described here.

The following paragraphs describe the options shown underneath the destination and source lists, with some guidance for input.

Heading

This is the column heading for the selected field in the Underview. If you leave this field blank the field label (or normal field name) will be used.

Column width

This is the width of the column for the selected field in the Underview. The number entered here should be a percentage of the total Underview table width.

Key field

When Calm records are linked to records in other databases, the contents of a unique code field are used to link the records together. For example when you link a Catalogue record to a Person record the code is displayed in the catalogue record in a field called PersonCode and in the Person record in a field called Code.

The foreign key is the name of the reciprocal linking field in the linked records. Enter Code for either the Persons database or the Places database.

➤