dbFront allows for the ability to add one or more views to a table. The purpose of table views is to make extra column information available. Examples are:
- Summary counts or totals of child records. e.g. Invoice Totals,
- The most current Permit Document.
- Include a picture of Staff Member who last served the current customer.
View Fields can be used everywhere that a regular table field can be used. This is includes, Reports, Exports, Row Security Expressions, Dropdown Columns, everywhere...
An obvious warning is that a poorly designed view can cause significant performance issues.
The Views are joined automatically on any matching fields to the primary table. For this reason you should name your view field names very carefully to ensure it only joins on the fields you intend. dbFront display the Key fields before you add the view to a table.
Note: Joins are allow on ANY regular field. This means you could use a view to bring in all kinds of information related to any aspect of a record.
The only requirement is that the view must return a single record for each key value. What this mean is, if your view is keyed on a ProductID, then it should return only one record for each different ProductID. It can return nothing but it can't return more then one record. dbFront will scan your view to ensure it does not violate this rule.