I am working on Oracle forms 10g (Windows 7 OS).I have got one requirement to show one LOV for COLOR table. Say i have three colors BLACK, RED, BLUE in color table. Suppose in a multirecord block if a user selects BLACK from a lov for one record then for the next record lov it should show only RED and BLUE. How to filter the COLOR from a LOV record group query which are already selected?
It could potentially be achieved, but there might be a problem if you have the use LOV for validation property enabled as the moment that you remove a value previously selected it becomes invalid.
On form load, read the values into a RG and on the WVI trigger of the field, add/remove values as they are selected/cleared.