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:

  1. Open the Next Key Definitions form.
  2. From the Primary Table drop-down list, select the table that contains the column for which you want to define a Next Key.
  3. From the Primary Column drop-down list, select the column for which you want to define the Next Key.
  4. Optionally, from the Primary Sub Key drop-down list, select the column you want to use for the sub key values.
  5. If the Next Key you are defining includes the use of a Master Table and Master Column, select those from the drop-down lists.
  6. If the definition needs to include a secondary Table, Column, and Sub Key, use those fields in the Secondary section of the form to specify them.
  7. Save the definition.
Related topics