Welcome to the Oracle APEX Foundation Course. Today in this lesson on Creating and Using Forms, I will be talking about Editable Interactive Grids and Master Detail Forms. Let's get started. In this lesson, you'll learn the different ways of creating an editable interactive grid. You'll also learn how to create an interactive grid. Further on, you'll learn more about master detail forms and how to create a master detail form in your APEX application. The slide shows the project details editable interactive grid created using the Create Page wizard. In an editable interactive grid, users can add to, modify, and refresh the dataset directly on the page. Editable interactive grids expand the functionality of regular interactive grids to enable users to more directly update a grid structure and contents. Users can add and delete rows, edit cell contents, and refresh the grid with the latest updates. Automatic row processing of DML is added by default when an interactive grid is made editable. Let us look at some of the key features of editing an editable interactive grid.

The grid is a navigation mode where arrow keys move from cell to cell. To enter edit mode, press the 'Edit' button or double click or press 'Enter' key on your keyboard or 'F2' key in a cell. To exit the edit mode, press the 'Edit' button or Press 'Esc' key in a cell. In the edit mode, the 'Shift + Tab' key moves to the previous cell. The 'Ctrl + Enter' key moves to the same column in the next row. Click the 'Add Row' button to add a new row. To delete rows, select the rows and click the top row actions icon and select 'Delete Rows'. The action menu also allows you to perform actions on the row, such as duplicate rows. The menu in the header is a selection actions menu that act on the current selection. The copy down, fill, and clear actions work with row or cell range selection.

Use 'Actions', 'Selection', 'Cell Selection' to toggle selection mode or press the 'F8' key. Editing is also supported in single row view. All edits are stored locally until you press the 'Save' button. If you try to leave the page while there are unsaved changes, you will be warned. Now, let's see how to create an editable interactive grid from the Create Application wizard. On the workspace homepage, click on 'App Builder' and select 'Create'. Choose 'New Application'. For name, enter a name used to identify the application. For appearance, accept the default theme style and menu layout, or you can change it by clicking the 'Set appearance icon'. Now we want to add a form. Click 'Add Page' and select 'Interactive Grid'.

On the Add Interactive Grid Page dialog, enter a page name. For table or view, select the database object for the grid. Alternatively, if you select SQL Query, enter a valid SQL Query which returns distinct columns. For table, I select EBA_DEMO_IR_PROJECTS. Notice the Allow Editing tab is selected by default. Click 'Add Page'. Under the Features, select the features to include with application. Under Settings, specify settings used to generate this application and click 'Create Application'. When you run the application and login to the application, you'll see the interactive grid created based on the table we selected. You can also create an editable interactive grid using the Create Page wizard.

To do so, click 'Create Page' and under Component, select 'Interactive Grid'. Enter a name for the page. Select a table or view name and most importantly, enable the Editing Enabled switch to create an editable interactive grid. A master detail form reflects a one to many relationship between tables in a database. Typically, our master detail form displays a master row and multiple detail rows. When you create a master detail form using the Create Page wizard or the Create Application wizard, you choose the table on which to build the master form and the detail form. This slide shows the three styles available when you choose master detail in the Create Page wizard. Stacked creates a single page master detail with editable interactive grids. Side by Side creates a single page master detail utilizing side by side layout and report regions with model edit windows. The left side contains a master list to navigate to the master record, the right side contains the selected master record and the associated detailed report.

Drill Down, creates a two-page master detail. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grid for the detail. Let us dive deeper into the Side by Side master detail form. A Side by Side master detail form contains a single page master detail utilizing side by side layout and report regions with model edit windows. The left side contains a master list to navigate to the master record. The right side contains the selected master record and the associated detailed report. You can create Side by Side master detail either Create Application wizard or the Create Page wizard. In the example shown on the screen, you can select a record from the master on the left, for example Accounting New York, to render the detail on the right without leaving the page. Now let us see how to create a Side by Side master detail using the Create Application wizard. On your workspace homepage, click 'App Builder' and click 'Create'.

Select 'New Application'. For name, enter the name used to identify the application. For appearance, accept the default theme style and menu layout, or change it by clicking the 'Set appearance' icon adjacent to the Appearance field. You want to add a master detail form. Click 'Add Page' and then select master detail. On the 'Add Master Detail Page', for page name, enter a name for the page. Select side by side layout, this creates a single page or side by side master detail with a master table and a detail table. The left side contains a master list to navigate to the master record. The right side contains the selected master record and associated detailed report. For table, select the master table. Here I select departments.

For primary display column, select the column to display as primary column in the report to navigate to a different master record. I select name. For secondary display column, select the column to display as a secondary column in the report to navigate to a different master record. I select location. For detail table, select the detail table for the page. Here, I select employees. Click 'Add Page'. Under Features, select the features to include with the application. Under Settings, specify their settings used to generate the application and click 'Create Application'. Run application. Login to the application, and you can see the master detail form created where the master table is displayed on the left. Selecting a master record will display the details on the right side of the screen. To summarize, in this lesson you learned the different ways of creating an editable interactive grid. You also created an interactive grid. Further on, you learned more about master detail forms and how to create a master detail form. I hope you learned something useful. Thank you for watching.