SharedTableName Property

Specifies the name of the shared Lookup table.

Syntax

object.SharedTableName [= String]

Properties

The SharedTableName property syntax has these parts:

Part

Description

object

An object expression that evaluates to an object in the Applies To list.

String

The name of the shared table.

Remarks

For ease of use the user is able to create shared threshold tables in the global pages for its Lookup objects to use. The Lookup object will then redirect all its lookups to this table.

The syntax would be something like:

"User.SharedThresholdTable1".

If the user does specify a shared table, all of its own levels are destroyed. The shared table allows for reuse of similar tables (color by value, for example) – making all objects consistent and allowing for any necessary changes to be made in one place.

 

Applies To