Identify Lookup Tables

When you need to display translated field information from multilingual schemas, you create a logical lookup table that corresponds to a lookup table in the physical layer.

A lookup table stores multilingual data corresponding to rows in the base tables. Before using a specific logical lookup table, you must designate the table as a lookup table in the logical table's lookup tables.

You can use lookup tables to display one set of values to users, while using a different corresponding set of values in the physical query. You can use the lookup table to provide human-readable values that are looked up in a different data source.