Set Required Fields

A column property can set whether a field is required.

Records containing fields that are Hard Required cannot be saved until the field is populated. Records with Soft Required fields can be saved but are not considered valid until the designated field is populated.

Applying the Soft Required column property automatically creates a view in SQL. DSP® then registers the view as a Validation Rule to the page and creates a default message that displays to the end user.

This feature is available for these control types:

  • Combo Box
  • HTML Area
  • Text Box
  • DateTime
  • Numeric
  • List Box
  • Text Area

Any field in a table that does not allow NULLS automatically displays as a Hard Required field in DSP®. In many cases it will be the Primary Key field. For example, the Order Detail page displays the Product ID field as required because it is a Primary Key, the Quantity fields and Discount fields are not automatically required because the table requirement allows NULLS.

To make a field required:

  1. Access the Page Columns page’s Vertical View for the field.

  2. Click Edit.

    View the field descriptions for the Page Columns page

  3. Select Yes (hard) or Yes (soft) from the Required list box.

  4. Click Save.