a humble request to please read completely first.

i am trying to prevent duplication while data entry in oracle apex Interactive Grid.
the IG contains first column of type Select List (it can be PopUp LOV or any suitable in version 23.1), i want Select List to not load or disable the values to select which are already currently in IG (saved or not).

i can prevent user to not enter duplicate after he/she selected a value which means we can process all data of IG which not yet saved (some helped me because i don’t know JavaScript). user want me to do not display or at least disable to select those values.

is there any way to prevent select list to not load those data exist in IG? like my LOV query use NOT IN to those entries (off course for very first entry in IG this should show ALL data to select from)

please help if it is possible.

regards