APEX 19.1 14 Create a master-detail form (2 tables) and simple form (1 table)

Опубликовано: 30 Октябрь 2024
на канале: J Kreie Database
37,811
202

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...

Look at the data dictionary (data model) and see where master-detail forms would be useful. Create a simple form which uses a single table. Edit the form layout. Next, create a master-detail form, which is based on two tables. Alter the SQL for searching records in a form. Unhide the primary key and foreign key fields to see how the master-detail form works.