Creating a View

From Wiki
Revision as of 09:14, 30 March 2012 by Sancho (talk | contribs) (1 revision)
Jump to navigationJump to search


A View is a query. Because of this, the details of how to create and use a View are in the Creating queries section.

File:VacationsTable.png
View of some fields from the Vacations table.

A View is also a table. Its fields come from the fields of one or more tables of the database. It provides a way to look at a number of fields without regard to the table to which any of the fields belong. A View can consists of some of the fields on one table as shown above. Or, it can consist of fields from more than one field as shown below.

File:BaseFieldsView.png
View of fields from the Fuel and Payment Type tables.
Documentation caution.png Data can not be entered into a View like it can be added to a table. It is strictly for viewing data which has already been added.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).