How do I add views?

Top   « Previous  Next »

 

Creating a View

 

Views are a subset of a database. When a database has many tables and fields, it's helpful to create a View so you only deal with a small part of the total data.

 

Lets create a View of the data which contains details about customers

 

Enter the View Name as 'Customers' and write a short description.

 

Tick the tick boxes for each table or field to include in this view, in this case we'll tick the Customers table, although we could only tick the fields we want to use.

 

Data Sources - Add View

 

The Field View shows details of each field. You can enter a description of each field if you choose and change the display name of the field to something more user friendly if the field name might not be easily understood by end users.

 

Click Save View to save the view.

 

Add other Views for different data if you want.

 

 

See also: How do I connect to a Database?