Custom Table Fields

The Custom Table Fields tab lists the fields that will appear on the custom table. It is hidden when adding a record.

 

Click the button to add a new field or click to open the Custom Table Field module. You can reorder the fields by clicking the up and down arrows.

 

Click Common Buttons for a description of the buttons found throughout the system and their uses.

 

 

 

Field

Description

Field Name

This column displays the names of the fields and groups them according to whether they are Unique Fields or Additional Fields based on the Is Unique Field check box on the Custom Table Field tab.

Caption

This column displays the field name that will appear on the screen when the user enters data.

Field Type

This column indicates the type of field that was selected. The types are:

  • CheckBox

  • Currency

  • Date

  • DateTime

  • DropDownList

  • Number

  • Text

  • Time

Display on List

A check in this column indicates that the field will appear on the custom tables list page. For example, if the custom table is for the Site base table, the custom table will appear on the Sites tab and on its own menu item. This field will appear on that menu item. The check is entered on the Field Properties tab.

Required

A check in this column indicates that the user will be required to enter data in to this field. The check is entered on the Field Properties tab.

Reorder

The two arrows move the rows up or down . Inactive records always will be excluded during the reorder process. When an inactive record is reactivated after the records have been reordered, then the record will appear at the end of the list.