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. 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.

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).
Specify the IDO Project Name and Table Alias for the IDO collection.
In the Subcollection Name field, specify a name for the subcollection IDO and table.
Use the grid at the bottom of the page to specify the properties and their attributes for the subcollection.
Click Next.
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.
From the Subcollection drop-down list, select the subcollection to be linked with.
From the Subcollection Property drop-down list, select the property from the subcollection to use as the link property.

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

The wizard displays the Subcollection Linkage, properly formatted.
Click Next.
The wizard displays the Finish page.
Optionally, to have the wizard create SQL scripts for the table and IDO, select the Create Scripts option.
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.
In this case, the wizard creates just the table and IDO and is finished. You can close the wizard.
To create a form to go with the table and IDO, click Yes.
In this case, the wizard creates the table and IDO and then opens the Responsive Form Builder wizard. Use this wizard to create your form (see Responsive Form Builder). When you are finished creating the form, remember to close the New Data Maintenance Wizard.