This function allows the user to dynamically link external objects to a specific function view, for example, the Application Messages function with the selected language value as the value of the primary key (language) or (autocad drawing link to a specific part number).
INQUIRE
The user must have a security profile linked to the function External Object Link with an access allowed of at least Inquire.
On this tab the following fields can be viewed:
The user must have a security profile linked to the function Link External Object with an access allowed of Add.
When a value is selected in the Column Value combo box, it is automatically inserted in the grid. When the "Add" button is clicked, it will be added to the Object Link table.
BUSINESS RULES WHEN ADDING:
1. The object must exist. 2. The table must exist. |
The user must have a security profile linked to the function Link External Object with an access allowed of Change.
The "Change" button is enabled when a record is clicked on or selected in the "Tables the object is linked to" list box. |
When you click on a field of the selected table's primary key, on the grid, for example, Language, it will display a combo box. All the valid values for that selected field will be displayed in the combo box.
The number of characters to be entered before the list is shown is governed by a dynamically determined populate length from a system table.
If the primary key consists of more than one field (composite), the combo box will be populated as above, but takes into account the previous values of the primary key. |
These are the valid values for the primary key field(s) for the selected Table, for example, if the selected table is Application Messages, and "Column Name" is language the valid value can be "E".
It is populated with all the valid values for the selected column name, for example, Language.
The number of characters to be entered before the list is shown is governed by a dynamically determined populate length from a system table.
If the primary key consists of more than one field (composite), the drop down combo box will be populated as above, but takes into account the previous values of the primary key. |
The user must have a security profile linked to the function Link External Object with an access allowed of Delete.
The "Delete" button is enabled when a record is clicked on or selected in the "Tables the object is linked to" list box. |
It is populated with the object name from the External Object table.
The number of characters to be entered before the list is shown is governed by the value of "populate length" (mandatory). |
This represents the tables and key fields that the selected object has been linked to.
When you click on a record in the list box, the "Change" and/or "Delete" buttons will be enabled depending on the security rights possessed by the signed on user.
When you click on the entry, the table name is inserted into the "Table Name" combo box and the fields making up the primary key is inserted in the "Column Names" column and valid values are inserted into the "Column Value" in the grid. |
It is populated with all the non-system tables. The external object can be linked to an instance of one of those tables. |