TD Table Designer

TD Table Designer - Keys tab

Navigator > Setup > Table Designer > Table Designer > Keys tab

You can define the index keys for a custom table. An index key is a data structure that improves the speed of operations. Index keys can be created using one or more fields of a table, providing the basis for both rapid look-ups and efficient access to records.

To show an Inactive Button on Lookup fields for the table, ensure the Table has the following two Indices:

Name ActiveMaster, having as the first field a boolean named Inactive, and the second field the lookup field. For example, ActiveProduct for ICPROD.
Name Master, having as the first field the lookup field. For example, Product for ICPROD.

See also Table Designer.

Note: Custom keys added to Accredo tables cannot be set as Unique (see below) as this could violate Accredo data rules.


Fields
No.		The ID number of the index.
Name		The name of the index on the table.
Unique		Selected, the index will be unique. Clear, non-unique index. Note: Custom keys added to tables cannot be set to Unique as this could violate Accredo data rules.
Primary		Selected, primary index for the table. May not be selected for indexes added to Accredo tables. Clear, non-primary index.
Parts		Select the fields that are to be indexed by this key.
ExNull		Selected, exclude null value fields from the index. Clear, null value fields will be included in the index.
Descending		Selected, index in descending order. Clear, index in ascending order.
Case Ins		Selected, the index is case insensitive. Clear, the index is case sensitive.
Encrypt		Selected, the key will be encrypted.
Cluster		Selected, indicates the key used for Optimise Tables.
Custom Key		Selected, indicates the key is a custom key.
Grid Toolbar
	Expand Toolbar `(Ctrl+F9)`		Expand the toolbar to give access to all toolbar options. Press `Esc` to close the expanded toolbar.
	Insert `(F4)`		Insert a new field at the selected line. Note: Table field and key schemas have a limit of size 65535. If a table schema exceeds this it cannot be saved. Tables exceeding this limit are not ideally designed, and should be redesigned.
	Move `(Shift+Up) (Shift+Down)`		Select a field and reorder the list.
	Delete `(F3)`		Delete the selected field.