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

From Wiki
Jump to navigationJump to search
 
Line 3: Line 3:
 
{{Documentation/GS3BaseTOC
 
{{Documentation/GS3BaseTOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block
|PrevPage=Documentation/OOo3_User_Guides/Getting Started/Creating database tables
+
|PrevPage=EN/documentation/ooo3_user_guides/getting_started/creating_database_tables
|NextPage=Documentation/OOo3_User_Guides/Getting Started/Defining relationships
+
|NextPage=EN/documentation/ooo3_user_guides/getting_started/defining_relationships
 
}}
 
}}
 
A View is a query. Because of this, the details of how to create and use a View are in the [[Documentation/OOo3 User Guides/Getting Started/Creating queries and reports|Creating queries]] section.
 
A View is a query. Because of this, the details of how to create and use a View are in the [[Documentation/OOo3 User Guides/Getting Started/Creating queries and reports|Creating queries]] section.

Latest revision as of 16:10, 11 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).