Promis.e Help

Index Table Editor

The Index Table Editor lets the user edit the Index Table.

Accessed from:

  • Manage Ribbon > Utilities Group
Button Name and Dialog When you select a button in the Button Name field and a dialog name in the Dialog field, the database columns for that button and dialog will appear.
New Adds a new row to the Index table. Blank setting fields will appear for the new row.
Edit To edit the displayed information, select the desired row and then select the Edit button. Editing (Setting) fields will appear for the selected row.
Delete Removes the selected row from the Index table.
Up Arrow/Down Arrow Allows you to move a selected row up or down in the list of rows (which affect the order in which the fields appear in the dialog).
Exchange Switches the positions of two selected rows (hold down the <Ctrl> key to in order to select the second row).

Index Table

The Index Table (IndexTable) allows you to control fields to display and the types of filter to use in each dialog.

ID Determines the order in which the fields appear in the dialog. The lowest number is the first field to appear in the dialog.
Dialog_Title Must match the dialog title in the button table which in turn tells the software which query to use.
Table_Name You can take data from more than one table. In the Table_Name column, give the name of the table from which the data is coming.
Field_In_Database The name of the field in the query.
Field_In_Filter Determines if the field will be displayed as a filter field in the dialog (such as the upper part of the dialog, selection field, neither or both).

Determines the type of filter that will be applied to that field.

  • Text - Indicates the records will be filtered for all records with the user-entered text as any part of the field. This is typically used for a description field where there are too many different entries to easily display in a list format.
  • Set - Creates a filter list that shows all possible entries that are available in the database for that field. Use this when the possible selections will fit in a manageable list.
  • CSV - Used when multiple entries may be available for a part. For example a lug may accept 12, 14, or 16 gauge wire. The data could be entered into the database as 12,14,16. The software would create a list filter but it would see this as three possible entries instead of one and 12, 14 and 16 would appear as separate selections in the list. The user could select any one of them and the part would be included in the filter.
  • Max/Min - Used when the user is expected to enter an actual value and all parts returned need to be above or below the user entered value.
  • URL - Used to designate a hyperlink field.
Filter_Label Used for the field name that will appear in the dialog.
Select_Label Used for the field name that will appear in the dialog.