Adding a subcollection in the Web Designer

When you add a subcollection as part of the New Data Maintenance Wizard process, the wizard automatically adds the "pages" required for the subcollection. Most of the fields and options on this page are the same as for the primary collection. An additional optional field allows you to assign a Subcollection Name that is different from the basic collection Name.

In addition, when you click Next to advance the wizard process, another subcollection-related page displays. You must use this page to provide the primary key and foreign key linkage information that the wizard needs to successfully create the form with the subcollection.

  1. After clicking Add Subcollection and seeing the subcollection properties page, in the IDO Name field, specify the name for the IDO collection to be used for the subcollection.
    See Using the New Data Maintenance Wizard (web client version).
  2. Specify the IDO Project Name and Table Alias for the IDO collection.
  3. In the Subcollection Name field, specify a name for the subcollection IDO and table.
  4. Use the grid at the bottom of the page to specify the properties and their attributes for the subcollection.
  5. Click Next.
  6. From the Primary Collection Property drop-down list, select the property from the primary collection to use as the link property.

    The wizard automatically displays the data type and primary key status of the selected property.

  7. From the Sub Collection drop-down list, select the subcollection to be used to establish the link.
  8. From the Subcollection Property drop-down list, select the property from the subcollection to use as the link property.

    The wizard automatically display the data type and primary key status of the selected property.

  9. Click Add Link.

    The wizard displays the Subcollection Linkage, properly formatted.

  10. Click Next.
  11. When you are finished defining the columns/properties/form components for the primary collection and any subcollections, click Next.
    The wizard displays the Finish page.
  12. Optionally, to have the wizard create SQL scripts for the table and IDO, select the Create Scripts option.
  13. Click Finish.
    The wizard displays a prompt asking whether you want to create a form to go with the table and IDO.
    • To create just the table and IDO, click No.
    • To create a form to go with the table and IDO, click Yes.
The Web Designer New Data Maintenance Wizard creates the specified IDOs, tables, and (if specified) form. If a form is created, the wizard displays the form in design mode.