Link Fields
Link Fields are the fields on your Calm records which are used to link records in different databases together. For example the PersonCode field in a catalogue record will link that catalogue record to a record in the Persons database.
When you choose the Link Fields option in the Configurator, a screen (as shown in this example) will appear. Please note: the example screen will open a new window, when you have finished and wish to return to this page, use the cross in the top right corner to close the window.
The fields you may use as link fields are limited to those that are used as
link fields in Calm. Link Fields can be added, removed and their order changed in exactly the same
way as Record Fields, described here.
You may set criteria to facilitate the viewing of linked records. The following paragraphs describe the
options which are located underneath
the destination and source lists, with some guidance for input. Fields highlighted
in red in the Configurator are mandatory.
Description
You may wish to set some text to appear on your Catalogue record to act as a
link to the Person or Place records.
Text you enter here will appear as the link, your users can click the link to
navigate to the linked records.
Link label
You may wish to re-label the link. The text entered here will appear in the Destination box when you save it.
This label is not displayed in CalmView, it is purely used in the Configurator. If you do not enter a label here, the original field name will be used as the link name.
Child data source
The child data source is the database in which your linked records are stored.
Choose CalmView.Persons or CalmView.Places from the drop-down list, depending on
which database you wish the selected field to link to.
Foreign key
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.