Home » Developer & Programmer » Forms » Lov should not repeat the value (Oracle 10g )
Lov should not repeat the value [message #533437] Wed, 30 November 2011 00:30 Go to next message
swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai
Member
Dear all,

I am using lov for one item on my form the form is in tabular format

when i select the value in lov for the item in first row
it should not be present agin in that lov for the next item

thus i want to prevent the duplication on Lov level can u hilp me
for particular problem

Swapnil
Re: Lov should not repeat the value [message #533476 is a reply to message #533437] Wed, 30 November 2011 03:41 Go to previous message
cookiemonster
Messages: 13926
Registered: September 2008
Location: Rainy Manchester
Senior Member
You'll need to post each record as it is entered. Probably by putting post in when-new-record-instance.
Then you can change the LOV query to exclude values that are in the table the block is based on.
Previous Topic: Change font size
Next Topic: Key-next-item
Goto Forum:
  


Current Time: Wed Jul 10 06:09:00 CDT 2024