APEX14.18.2: Master-detail forms are greatly improved. See how easy it is with APEX 18.2
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...
This video uses APEX 18.2 and shows the differences between version 18.1 and 18.2 when creating master-detail forms. A search feature for the primary key value is added and the primary key value is displayed, not hidden.
Correction: At 8:24 in this video I say "semi-colon" when I should have said "colon."
SQL code for the WHERE clause:
where (:P12_SEARCH is null
or upper(x."LNAME") like '%'||upper(:P12_SEARCH)||'%'
or upper(x."FNAME") like '%'||upper(:P12_SEARCH)||'%'
or upper(x."PERS_ID") =:P12_SEARCH
)
order by "LNAME"
