How to link records: using the Find data for the field box

The Find data for the field box displays a list of values (names / terms and so on), each one of which points to a record in the target data sourceClosed A link is made from a record in one data source (primary) to a record in another data source (target). A data source could be both the primary and target data source in a linking relationship if one of its records links to another of its records.. It can be accessed by clicking the icon in a Linked fieldClosed A type of field used to link one record to another. A Linked field is a drop list of values (records that the field can link to). When a link is made, the field stores a reference to the linked record (a linkref).; when adding or editing a record, if you enter a value in a Linked field that is not in its drop list, e.g.:

Add new name

the Find data for the field box will automatically open when you leave the field (click Tab or simply click away from the field):

Find data for the field

Several tabs are provided, each one offering a different way to view Linked field values. Which tabs display depends on how the field has been configured:

We link to a record by selecting a value on one of the tabs; if a value we are looking for does not exist in the target data sourceClosed A link is made from a record in one data source (primary) to a record in another data source (target). A data source could be both the primary and target data source in a linking relationship if one of its records links to another of its records., we can create a record and link to it.

Additional options