Linked columns can have different size¶

What is new - 8.1¶

Linked columns must be of the same type, but can have different sizes. This is useful, for example, to link to older versions of the same or related tables whose length may have changed over time.

For example, you can now link an int column of length 8 to an int column of length 4, or even different integer types, such as smallint to int. Keep in mind that linking columns of different sizes can result in not being able to match all data.

For example, a report may try to link a value in an int column to a smallint column; when that value is outside the range of the smallint column (e.g. > 32,768), it will not succeed.