Creating Lookup Links

  1. Select the fields you want to match on from the Source and Target panes.
  2. Click Lookup link.
  3. Select the Lookup Criteria Tab to view or edit lookup criteria for the new Lookup Link.
  4. From the Lookup Criteria tab, you can add a formula or scalar function to the link.

Note: To ensure optimal performance, create a corresponding index in the target on the selected fields.

You can add a Comment to a Lookup link.

See also

About Lookup Expressions

Using Source Expressions

Seek

Using Operators in a Lookup Expression

Using Scalar Functions in Lookup Links

Viewing Field Properties