APEX 19.1 19 Uniqueness constraint on 2 columns. Add computation to a page item in form.
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...
Add a column to the lookup table so it can reference another table for cascading LOVs. For example, each breed is associated with an animal category, such as collie is associated with canine. Add a uniqueness constraint for animal category and dominant breed so that collie and canine can’t be entered more than once in the lookup (reference) table. Create a report with form for each lookup (reference) table. Use a computation to convert all text to uppercase for any text entered in the form.
