When a gadget has a foreign table, the actual value of the column to which it is tied is compared with a value column in the foreign table to identify a value to be displayed from the foreign table display column. It is therefore important to ensure that the type of gadget column and the foreign table value column are the same.

If the type is not the same, the comparison between the actual value and the value column is not possible. Values must be of the same type for a comparison to produce a useful result.