table reference

A link to a table from which something must be selected or where additional information about something is stored.

Example

The Items - General (tcibd001) table has a Country of Origin (tcibd001.ctyo) field . This field has a reference to the Countries (tcmcs010) table.

If you enter a country code in this field, LN does the following:

  • Checks whether that code is present in the Countries (tcmcs010) table.
  • Retrieves the country's description from the Countries (tcmcs010) table.
  • Displays the country's description on the form.

Hard references are defined in the table definition.

Soft references are not defined in the table definition, but programmed in a program script or dll.

reference