Table Views - New
It is now possible to add one or more views to a table. The purpose of table views is to allow you to make extra information available to the user. Examples are:
- Summary counts or totals of child records. E.g. Invoice Totals,
- The most current Permit Document.
- Include picture of Staff Member who last served customer.
View Fields can be used everywhere that a regular table field can be used. This is includes, Reports, Exports, Row Security Expressions, everywhere...
An obvious warning is that making a poor choice of views will 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.
The feature is real... were working on the documentation...