Defining Next Key metadata

Next Key specifications for new tables and columns can be defined using metadata that the PopulateAllNextKeysMetaSp stored procedure can use when synchronizing or otherwise processing Next Key data.

To create a Next Key metadata definition, use this procedure:

Open the Next Key Definitions form.
Initiate a new record.
In the Primary section, provide this information:

Table

(Required) Select the table that contains the column for which you want to define a Next Key.

Column

(Required) Select the column for which you want to define the Next Key.

Sub Key

Select the column you want to use for the sub key values.

Master Table

If the Next Key you are defining includes the use of a master table, select the table.

Master Column

If the Next Key you are defining includes the use of a master table, select the column to be used as the master column.
If the Next Key involves the use of a secondary table, in the Secondary section, provide this information.

Table

Select the table that contains the column for which you want to define a secondary Next Key.

Column

Select the column for which you want to define the secondary Next Key.

Sub Key

Select the column you want to use for the secondary sub key values.
Save your work.