Creating a user-defined table

To add a user-defined demographics tab, you first need to name and define its data table, unless a previously defined table contains the fields you want to add to the tab you are designing.

If you want to display the data from this newly designed table, after the table is defined, create the tab, and add the data fields that you want to display on the tab. Here's an overview of the process:

1. Create the table and add the fields.
2. Create a window - either auto-created or create your own.
3. Use the Build command in iSA > User defined tables > Build to build the underlying business object.
4. Add the window to user tab preferences.
5. Enter data for members and then the definition is complete.

   Note: Lookup is unavailable for numeric user-defined fields. When defining a field that uses a general lookup/validation table, make sure you do not assign a numeric Type to the format (for example, a number).

   Note: If you assign a numeric Type format to a field, iMIS automatically formats the numbers entered in the field with commas. If you do not want a user-defined field to be automatically formatted, assign the data type to Char.