User Extended Tables Overview

The User Extended Tables (UET) feature gives the system administrator the ability to extend existing application database tables and add custom user fields to forms in the application. Use this feature to keep track of information that is not currently in the application database schema.

Note: If you are using replication, you must click the Regenerate Replication Triggers button on the Replication Management form after UETs are changed, added, or deleted.

Tables are a systematic arrangement of data in records and fields for ready reference. The application ships with tables containing predetermined fields. The UET feature allows users to add their own fields to these tables.

Once a table is extended, you can drop user fields into any application form that uses this table.

Note: If you bind a new component to a UET on a form that uses a custom load method stored procedure, an error message displays when you refresh the form. However, the error does not prevent you from continuing.

Only the Primary table of the Form's Primary Collection is extendible on that form.

See Finding the Primary Collection for a Form.

When data is entered into pre-existing fields, and if the rule expressions you defined for those fields are true, the events to arrange and display information in new custom user fields are triggered.

To add new user fields to forms, see Extending Application Database Tables.

Reports

These reports are available to view information about UET user classes, user fields, user indexes, and user tables.

Quick Dictionary Report

User Class Report

User Fields Report

User Index Report