Master-Detail Relationship in Oracle Application Express 18

CG.

To create a master-detail relationship between two interactive grids on a page in Oracle Application Express 18, you must perform the following steps:

Step 1: Create a Master Interactive Grid region Firstly, you need to create a master interactive grid region. This is the grid that will act as the master in the relationship. You can add this region to the page using the "Create Region" wizard in Oracle APEX. In the "Region Type" section, select "Interactive Grid" and specify the SQL Query that will be used to populate the grid.

Step 2: Create a Detail Interactive Grid region Next, you need to create a detail interactive grid region. This is the grid that will act as the detail in the relationship. You can also add this region to the page using the "Create Region" wizard in Oracle APEX. In the "Region Type" section, select "Interactive Grid" and specify the SQL Query that will be used to populate the grid.

Step 3: Define the Master-Detail Relationship To define the master-detail relationship between the two grids, follow these steps:

a. In the master interactive grid region, select the detail interactive grid region in the "Detail Region" attribute.

b. In the detail interactive grid region, select the master interactive grid region in the "Master Region" attribute.

c. In the detail interactive grid region, select the foreign key constraint that relates the detail table to the master table in the "Detail Region Foreign Key Relationship" attribute.

d. In one of the columns of the detail interactive grid region, select the related column of the master interactive grid region in the "Master Column" attribute. This will create a link between the two grids based on the selected columns.

Note that it is not necessary to make the master interactive grid region read-only. However, if you want to prevent users from making changes to the master data, you can set the "Editable" attribute to "No" for the master region.

Finally, you may choose to move the detail interactive grid region below the master interactive grid region to improve the user interface.

In summary, to create a master-detail relationship between two interactive grids in Oracle Application Express 18, you need to select the correct regions for the "Master Region" and "Detail Region" attributes, define the foreign key relationship between the two regions, select the related columns in the "Master Column" attribute, and optionally make the master region read-only.