Associate Additional Source Data - Intergraph Smart Instrumentation - Help

Select the link and select .

In the Link Properties dialog, select the Source tab.

Under Source tables, select Define.

In the Associate Source Data dialog, select Add to add a data set (for example, a table or a database file) to the Source list data window.

Repeat the previous step to add as many data sets as required.

It is possible to use the same table more than once as a source.

Highlight the data set to associate to and under the Association group box, select Select. The selected data set is copied to the Source for association data window.

Expand the data sets as in each data window by double-clicking them, then drag the required item in that data set to the appropriate data set item in the Source for association data window.

The association between the two data items is indicated by the appearance of an icon () to the right of each data item in the appropriate section.

In Smart Instrumentation, table columns contain numbers (num type columns) and characters (char type column). You cannot associate a num type column with a char type column or the other way around.

Repeat the previous step to associate other data items as required.

• You can associate several items with a single data set item, however, you cannot associate data from a data set with itself.

• To delete an association, select the item in the Source for association data window and press DELETE on the keyboard.

Select Verify to make sure your selections are valid (this way you can check, for example, whether the associated table columns are both the same data type - numeric or alphanumeric).

An appropriate message is displayed: if the associations are valid, the total number of rows of the source data set (including the associated data) is indicated, or else you are notified that the associations are invalid, in which case you should correct your selection in the Source Associations dialog.

Select Confirm.

When prompted, select Yes to save your associations.

The data sets disappear from the right data window and appear at the top of the left data window.

To make the fields of the associated data appear in future dialog boxes, do the following:

1. Expand the associated data sets by double-clicking them.

2. Select once on every item you want to view.

The icons appear as follows:

Item selected:

Item not selected:

You can view the contents of an associated data item in the Import Link window. To be able to view the associated data, select when available, after you select the required table. For further details, see Viewing the Source Data.

Make sure you remove all disassociated tables from the data windows in the Source Associations dialog before you select Save.

Select Save to save your association.

In the Link Properties dialog, under Source Associations, do one of the following:

• Select Apply to use your associations in the current import process.

• Clear Apply to skip the defined associations.