The Detail field is a device that allows the creation of a Form consisting of Master and multiple rows of Detail data as may be required for such applications as Quotations, Sales Order Confirmations, Invoices, etc. In most forms applications, the Global template will be the best Master format to which to add the Detail field object.
Ordinarily, when a Template (Global or Subledger) is saved, STEP FORWARD creates a single database table with the structure based on the composition of the template. However, when a Subledger or Global Template includes a Detail field, STEP FORWARD creates two database tables:
It thus creates a pair of tables that implement the often-required Master-Detail (a.k.a. one-to-many) relationship, where one record in the Master table is related to a group of records in the Detail table. The Detail table is not available for editing using the Update, Insert, or Delete objects.
Structuring the data rows
When you grab the Detail field icon from the Palette it leaves its holding well empty, since only a single Detail field object (containing many rows and columns) can be present in any one Template.
During actual data entry, the Status buttons indicate, through their color code, the status of the data row:
|Magenta: row available for data (the initial default setting)|
|Green: entered data is Complete (all conditions are met)|
|Yellow: entered data is Suspended (e.g. a mandatory field lacks data)|
The Detail Box Style Inspector view has a special feature. It allows the addition of a horizontal scrollbar to the Detail object for those situations where the combined widths resulting from the number and size of the field columns is greater than the form design can accommodate:
You can increase the number of fields (columns) to be included in a data row by dragging a Data field, a View field, or a "linked field" (by dragging a Grab icon from a Global source table - select from the Palette after setting the appropriate pop-up list to the desired Global table name).
After landing the new field in the Data field object, the new Data field will be added as a new field column to the right of all existing columns:
You can reposition the various field columns by dragging the columns to the intended positions (remember that the Detail field object must be welded to the Workspace, by double-clicking on it.
The number of data rows per Master/Detail document is unrestricted (as are the number of fields per data row, subject to any limitations imposed by the RDBMS used). However, the visible number of rows and columns are controlled by the physical size of the Detail field object which can be resized by dragging the control points.
The field columns can be adjusted as to individual width by dragging the field separators in the header area.
Table of Contents
Using the Detail Object
Global Template - Topics of Interest
Subledger Template - Topics of Interest
Transaction Template - Topics of Interest