This content has been marked as final. Show 3 replies
Steve Cosner wrote:It's interesting. I heard it for the first time.
I believe I have read somewhere that the double LOV pop-up is a bug in forms that occurs when there are identical values in the LOV.
The oracle official forum member should discuss on this issue.
What i know...
We are thinking on entire row and we know and confirm it's identical like poster example. Then, why LOV pop up again ?
LOV only pop up again if you set the LOV assigned item property "_Validate from list_" is "_Yes_". The filed only takes one column value and it's check the identical value, but the record column aren't indentical. For example from poster is: a1, a1. so, it's pop up again and then take one value.
If you set "_Validate from list_" is "_No_", you can write what ever you want at lov assigned filed and it let you go but the data is wrong !
You may try one thing. i didn't test.
Take When-Validate-Record-Trigger at block level and set the Validate from list to No
Take When-New-Record-Instance at block level and set the Validate from list to Yes
Hope it's help
If someone's response is helpful or correct, please mark it accordingly.