we have a table which is used in multiple pages as detail (apex: interactive grid), there is a FLAG field which contains OPEN and ADJ , we want unique entry with every Item in case of Flag value is OPEN only otherwise it can have multiple entries of each item.
is there a way to achieve this? if yes, how it can be done? please help.
regards