Under Tools > Matching Search Configuration in the TABLE|IT Table Manager you can configure the search for values from a table in another table.

 

 

The following dialog will appear:

 

 

Choose the table whose values you want to use for your search (1) as well as the table you want to search in (2). Then click on Load columns (3). The columns of your source table (1) will appear below. Now you need to specify in which column (4) you want to search for the value of your source column as well as an operator (5) (the types of operators available depends on the data type) that defines how the search is done. In the example above the Printer ID should be a part of the Hardware ID and the Hardware Name should be equal to the Printer Name.

 

In the end you click on Save. The window will close automatically.

 

In case you do not want to apply the changes you have made you can click on either Delete or Cancel.