Edit Collection Specification for Subcollection dialog box

Specify the properties of a subcollection.

Collection Source

Property Description
Parent Collection The name of the parent collection.
Subcollection Property The subcollection property as defined on the parent collection.
Custom Load Method A custom load method for loading data into the subcollection. This attribute should be specified only if the standard default method of loading the subcollection is inadequate. This is usually required only in very advanced applications.
Method Parameters Parameters passed to the custom load method. Parameters may include literal values, IDO properties, variables, or components.
Base Table and Alias The name of the primary table and its alias for the parent collection IDO. Read only.
Read Mode The isolation level for transactions when loading the collection. See the Read Mode property.

Standard Operations

Property Description
Navigate The user may navigate to the first, next, previous, and last IDO items of the queried subcollection.
Refresh The user may requery data into the subcollection.
Filter The user may specify filter criteria for data queried into the subcollection grid.
New/Copy The user may create a new IDO item in the subcollection.
Save The user may save changes made to IDO items in the subcollection.
Delete The user may delete IDO items in the subcollection.
Notes The user may attach notes to IDO items in the subcollection.
Spreadsheet Disabled Does not apply to subcollections.
Graph The user may generate an ad hoc graph of data in the subcollection.

Advanced Options

Property Description
Record Cap Override Specifies a record cap for the selected collection. This number cannot exceed the WinStudio maximum record cap, if it has been specified on the Process Defaults form.  
Operate as Primary Unbound or variable-bound components are typically associated with the form's primary collection. For instance, variable-bound components are reinitialized when the user inserts a new IDO item in the primary collection. This option allows you to designate another collection or subcollection to be associated with these components.
Reload after Save Refresh the whole subcollection after a save.
Reload after Child Save Refresh the parent collection after the child subcollection is saved.
Defer Refresh Until Visible Do not populate the subcollection until it becomes visible to the user. This option is useful for cases in which subcollections or secondary collections are displayed on notebook tabs. If this property is specified, the collection is not queried until the user selects the tab that contains it.
Save One Row Per Transaction This option is not available for subcollections. When this option is applied to a top level collection, it affects both the top level collection and all subcollections.
Load/Save Overrides Specify custom procedures for update, insert, delete and post-query processing.
Set LinkBy Define the relationship between the parent collection and the child subcollection. This is usually specified as a set of IDO property pairs in which one property in each pair is from the parent collection and the other is from the subcollection.

Subcollection Name and Filter Form

Property Description
Collection Name A string name or literal value that is used to identify the subcollection in error messages and menu options. This name should be appropriate for end users.
Filter Form The name of the form used to define ad hoc filter criteria for the subcollection.

Selection Options

Property Description
Filter A permanent filter that is applied to the subcollection. Ad hoc filter specifications set by filter forms or Filter-in-Place are added to this filter when querying the subcollection.
Distinct Remove duplicate records from the returned data. If this option is checked, data cannot be reliably updated. It should only be used for read-only data.
OrderBy A comma-delimited list of IDO properties that are used to sort the collection. The default order is ascending. You can define the order of any of the properties by specifying either desc or asc following the IDO property name.
GroupBy A comma-delimited list of IDO properties that are passed to the IDO, which converts them to a SQL GROUP BY clause and passes them to the application database.

How to Get There

To open this dialog box:

  1. Open a form that uses a subcollection.
  2. Go into Design Mode.
  3. Select the subcollection.
  4. In the Component property sheet, navigate to the Data Binding section.
  5. In the Binding field, click the ellipsis (...) button.
Related topics