Hi,
On a tabular form, for one LOV column, when I pick a value, it would need to be unique in that column.
Since I'm not sure how to do this on frontend, validation on submit would work fine.
Validation would not allow same value to be selected on more than one row for that column.
The idea is to use:
FOR i IN 1..apex_application.g_f01.count LOOP
IF apex_application.g_f08(i) ...etc
But I'm little confused with using the collections with tabular forms and referring to columns and values. In this example: http://theperfectbeast.blogspot.com/2015/02/oracle-apex-advanced-tabular-form.html
why are the second and third columns in this example f03 and f04
How would I refer to the 9th column in my tabular form, if first one (ID) is hidden?
Basically how should I use f01 array, while comparing to the selection from the table if the value already exists there?
(then if value already exists in table and was chosen twice in a LOV, while submitting, validation would then return error message)