DB Query to use the database views
-
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.Tables is selected and all tables within the selected database are available on the Table list.By default,
-
For Type, click
Views.
All existing views appear.
- On the Views list, select the view to retrieve records for.
- Configure the query in the same way as for viewing a table. See DB Query to view records in a table.
- Click OK.