There are three types of Subject you can build. Freeform Subjects allow you to combine related tables which have Links between them, or you can achieve more complex Subjects by creating them from Business Logic Procedures or PROGRESS Smart Data Objects .

All DataPA Queries are based on Subjects.  Subjects are a way of controlling the Query building process, preventing the use of unrelated tables, inefficient sorting on non-index columns, inefficient finds on non-index columns and the display of sensitive or system data.

By grouping together related tables and allowing you give columns appropriate labels, Subjects also simplify the Query building process for the end user by removing the need for any knowledge of the structure of the underlying application database.

Using the Subject Wizard, you can Create a New Subject or Modify An Existing Subject quickly and easily.

Alternatively it is possible to use an Clone an Existing Subject.

Using the Subject Explorer you can enquire on, select (if you currently have the subjects tab selected) and search for particular subjects.