Relational Indexes
Descriptions in the following parameter table are specific to Relational indexes.
^Parameter^Description^
| Desttable | The destination table for relational indexing information. desttable stores detail information about the master table. |
| destcolumn | Specifies the multi-valued column in the destination table that stores the list of related keys from the master table. |
| Sortmode | Specifies the order in which the indexed data is stored. sortmode parameters are: Value - Sort order - Description 1 - TOP - Put the most recently indexed data at the top (beginning) of the index (reverse chronological order). 2 - BOT - Put the most recently indexed data at the bottom (end) of the index (chronological order). 3 - AL - Put the indexed data into alphabetical order (ascending, left justified). 4 - AR - Put the indexed data into numerical order lowest to highest (ascending, right justified). 5 - DL - Put the indexed data into reverse alphabetical order (descending, left justified). 6 - DR - Put the indexed data into reverse numerical order, highest to lowest (descending, right justified). |