Form Designer Memory Table Designer

Form Designer Memory Table Designer - Keys tab

Navigator > Setup > Form Designer > Layout tab > Memory Table Component > Double-click > Keys tab- OR -

Navigator > Setup > Form Designer > Layout tab > Memory Table Component > Right-click > Table Editor > Keys tab

You can define the index keys for the memory 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.

Note: Custom keys added to Accredo tables cannot be 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 must be unique. Note: Custom keys added to tables cannot be set to Unique as this could violate Accredo data rules.
Parts		Select the fields that are to be indexed by this 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.
	Move `(Shift+Up) (Shift+Down)`		Select a field and reorder the list.
	Delete `(F3)`		Delete the selected field.