This part of the wizard creates a grid view for data from one or more collections.

You can assign data object hierarchically in the process. This means that data objects which are defined as dependent (foreign key relation) on another database object stored in the same or another collection can be displayed in another layer.

To create a grid display for collection data

1. For example, mark a node of type Container, and, in the context menu, select the Wizards | Create data display item.
2. In the Display wizard dialog, select the Create a grid display for collection data option and click OK.

   This displays Collection. You can apply the following settings.

   Table 53: Collection settings

   Option	Setting	Description
   Use foreign key relation		Selection box with a list of available foreign key relations.
   Use existing collection		Selection box with a list of available collections.
   Create a new collection		Adds a new collection.
   	Base table	Database table selection.
   	Collection name	Input field for a collection name.
   	WHERE clause	SQL input box for setting filter conditions. Use to open the wizard for setting filter conditions.

3. On the Collection page, configure the settings and click Next.
4. On the Columns page, select the database columns for which you want to display detailed information and click Next.
5. Configure the following details on the Layout page and enter a name for the layer.

   Table 54: Layout settings

   Setting	Description
   Layer name (Identifier)	Gives the layer a name. The layer caption is only used help the search for properties that you may want to change later.
   Display title	Enables/Disables the title display.
   Enable the user to sort columns	Allows the user to sort data objects in their own way. Grid contents can be resorted by clicking the column title bar.
   Sort collection	Sorts the collection according to a set criterion. The criterion is set using both selection boxes.

6. Click Finish.

   This data completes the definition of the first grid layer. Another window opens. This window displays the grid layers that are already defined.

7. Perform one of the following tasks:
   1. Add another grid using .
   2. Mark the existing grid and edit it using .
   3. Mark the existing grid and delete it using .
8. Confirm the Create a new grid - layers pane with Ok.