|
GoldBox Views
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
The example below illustrates some of the special capabilities of GoldBox Views. Click on the thumbnail to
see the View. The text describes some of the View's more notable features.
see the View. The text describes some of the View's more notable features.
Current/Prior Employers View
This View is designed to reduce the required screen "real estate" for the View to about
25% of what it would otherwise be, while utilizing all UDF fields....
The above View looks very similar to a Detail Expander View, but it is not one. Despite having multiple
records, the fields in each of those records are actually different groupings of User-Defined fields. Why?
While it's possible to create a simple query tool for Details using a GoldBox QBE View, there are limitations
that quickly become apparent when attempting to work with multiple Types of Details, and with complicated
logic, within a single query. In this case, my client wanted to avoid those issues, and stick with User-Defined
fields, which are much easier to query.
Having made that decision, we then had to confront the fact that we had to deal with 4 X 12 = 48 fields, each
with considerable length. If these fields were to be displayed in the usual way, the overall size of the View
would be very large...and we had to accommodate two other Views that might be open at the same time.
The solution was to, in effect, "fold" the View into 4 parts, each a record. This would, for technical reasons,
require a Q-file with 4 Import/Updates to handle the different sets of fields involved, but that was a simple
matter to handle.
So, when entering data, we have the space economy of a Detail Expander View; while retaining the query
simplicity of User-Defined fields...literally the best of both worlds! Note: the screenshot shown was made
during testing, so the data in the View is testing data, not real world data.
records, the fields in each of those records are actually different groupings of User-Defined fields. Why?
While it's possible to create a simple query tool for Details using a GoldBox QBE View, there are limitations
that quickly become apparent when attempting to work with multiple Types of Details, and with complicated
logic, within a single query. In this case, my client wanted to avoid those issues, and stick with User-Defined
fields, which are much easier to query.
Having made that decision, we then had to confront the fact that we had to deal with 4 X 12 = 48 fields, each
with considerable length. If these fields were to be displayed in the usual way, the overall size of the View
would be very large...and we had to accommodate two other Views that might be open at the same time.
The solution was to, in effect, "fold" the View into 4 parts, each a record. This would, for technical reasons,
require a Q-file with 4 Import/Updates to handle the different sets of fields involved, but that was a simple
matter to handle.
So, when entering data, we have the space economy of a Detail Expander View; while retaining the query
simplicity of User-Defined fields...literally the best of both worlds! Note: the screenshot shown was made
during testing, so the data in the View is testing data, not real world data.
