Lookup fields are used to add a field to a table in order to retrieve the value of the field in another table. The process of adding a conditional lookup field consists of a number of steps described below.
The next step is to specify the field to be used as lookup field. You can add multiple lookup fields to one conditional lookup field.
Expand the field, and then right-click Lookup Fields. Click Add Lookup Field.
Click OK.
You can also drag a field from one table and drop it over the name of another table. This will create the conditional look up field, but we still need to add joins. Adding joins are covered below.
Next step is to join the source table with destination table using similar columns. Less complex joins will make the lookup perform faster. To get the best performance, use one single numeric field for the join.
You can specify conditions for the lookup. The lookup takes place when the condition evaluates to true. Below are steps to add conditions to a lookup field.
Specify the following