Home » Developer & Programmer » Forms » Dynamic record group to filter selected values in a multirecord block from a LOV (Oracle Forms 10g, Windows 7 )
Dynamic record group to filter selected values in a multirecord block from a LOV [message #589643] Tue, 09 July 2013 06:42 Go to next message
pramod.sramesh
Messages: 23
Registered: November 2011
Location: Bangalore
Junior Member
Hi Experts,

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?

Thanks,
Pramod SR

Report message to a moderator

Re: Dynamic record group to filter selected values in a multirecord block from a LOV [message #589647 is a reply to message #589643] Tue, 09 July 2013 06:52 Go to previous message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use the post command in when-new-record-instance to post each record as it's entered.
Then modify the LOV query to exclude values already written to the DB.

Report message to a moderator

Previous Topic: Barcode Label Printing - Can I prevent the label from printing 'N/V' for null values?
Next Topic: Time in List Item
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 02:52:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.