Skip to Main Content

Breadcrumb

Overview: Master Detail

There are wizards to help create master detail Interactive Grids but it is easy enough to set up manually to get exactly what you want. Follow these general steps as was done for this example.

  • Add the master Interactive Grid and the detail Interactive Grid.
  • Configure the columns and set the primary key(s) for each and in the case of this example enable editing.
  • Then on region attributes for the detail grid set the Master Detail: Master Region attribute to the master grid region. The DEPTNO column is the foreign key to the master table so set the Master Detail: Master Column to DEPTNO (the primary key of the master table).
  • Make sure the detail grid toolbar save button is disabled.

Departments

Employees

Select 1 row in the parent region
Grid row sequence 1, Column 1.