Difference between revisions of "EN/documentation/ooo3 user guides/getting started/creating a view"

From Wiki
Jump to navigationJump to search
m (1 revision)
 
Line 1: Line 1:
{{DISPLAYTITLE:Creating a View}}
+
<section begin=title /><noinclude>{{DISPLAYTITLE:</noinclude>Creating a View<noinclude>}}</noinclude><section end=title />
 +
 
 
{{Documentation/GS3BaseTOC
 
{{Documentation/GS3BaseTOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block

Revision as of 17:52, 8 April 2012



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).