Create a database view

Create the database view.

  1. Navigate to System Definition > Database Views.
  2. Click New.

    The Database View form appears.

  3. Name the view as you would name a new table.
    The application converts capital letters to lower case and spaces to underscores.
  4. Provide a label and a plural.

    The Label and Plural fields define how the database view is labeled in lists and forms.

    Figure 1. Database view configuration
    Database view configuration
  5. (Optional) Provide a description of the database view so that other users know its purpose.
  6. Click Submit.
    The database view is added to the Database Views table.