OraFAQ Forum: Forms » Master detail form

Home » Developer & Programmer » Forms » Master detail form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Master detail form [message #540820]

Wed, 25 January 2012 21:15

deepu2022
Messages: 5
Registered: January 2012
Location: USA

Junior Member

Hello All,
I have a master detail form. I have one column in master, which is a free text field and one in detail block which is a LOV. When I enter data in the master block and select say A,B,C records in LOV in detail block and saved it. These A,B,C records in LOV shouldn't appear in the detail block when a new record is entered in the master Block.

Please help me
Deepu

Thanks in advance!

Report message to a moderator

Re: Master detail form [message #540828 is a reply to message #540820]

Thu, 26 January 2012 00:06

azamkhan
Messages: 557
Registered: August 2005

Senior Member

I think you should use a where clause in the record group of the LOV

Report message to a moderator

Re: Master detail form [message #540829 is a reply to message #540828]

Thu, 26 January 2012 00:48

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

One option is to POST records entered into the detail block, which would - together with a WHERE clause @azamkhan suggested - probably do what you are looking for. Something like

select some_value
from some_table
where some_value not in (select the_same_value
                         from detail_block_table
                         where some_id = :master_block_id
                        )

Report message to a moderator

Re: Master detail form [message #540977 is a reply to message #540829]

Thu, 26 January 2012 17:17

deepu2022
Messages: 5
Registered: January 2012
Location: USA

Junior Member

Thanks alot guys! I used the above logic to fix it.

Report message to a moderator

Previous Topic:	SENDING EMPLOYEE PAYROLL SLIP
Next Topic:	what are the parameters for app_window.set_window_position()

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 06:10:11 CDT 2024