Welcome > Form Designer module > Add actions to a form or control > Add actions > Create a DB query > DB Query to use the database views

DB Query to use the database views

  1. On the DB Query Action page of a form, or on the Extended Properties page of a Data Access activity, click Configure.
    The Database Query page appears.
    Note By default, Tables is selected and all tables within the selected database are available on the Table list.
  2. For Type, click Views.

    All existing views appear.

  3. On the Views list, select the view to retrieve records for.
  4. Configure the query in the same way as for viewing a table. See DB Query to view records in a table.
  5. Click OK.