Create a Hierarchical Data Grid

You can create a multilevel hierarchical data grid to map multiple data sources.

In the following example we create one non parameterized lookup (Work Order) and three parameterized lookups ( Jobs, Job Steps, and Job Steps Data). Then, we create a four level hierarchical data grid using the lookups and map all the parameters.Then, design a form and use this data grid in the form using the Data Grid control.

1. Create the following four lookups:

   1. Work Order -Non-parameterized

   2. Jobs - Parameterized on the Work Order lookup(wo_id)

   3. Job Steps -Parameterized on the Jobs lookup (wo_id, oper_id, seq_no)

   4. Job Steps Data - Parameterized on the Job Steps lookup (wo_id, oper_id, seq_no, step_no)

2. Create a four level, hierarchical grid configuration and name it as MES Configuration.

3. Select the data sources in the same order as the lookups created in step 1 .

4. Click Parameter Mapping.

   The parameter mapping screen appears. Map the child parameters to the parent column.

5. Save the parameter mapping and the grid configuration.

6. Design a form and consume the grid configuration, MES Configuration in the Data Grid control.

7. Click Preview.