Home » Developer & Programmer » Forms » Master detail form
Master detail form [message #540820] Wed, 25 January 2012 21:15 Go to next message
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!
Re: Master detail form [message #540828 is a reply to message #540820] Thu, 26 January 2012 00:06 Go to previous messageGo to next message
azamkhan
Messages: 495
Registered: August 2005
Senior Member
I think you should use a where clause in the record group of the LOV
Re: Master detail form [message #540829 is a reply to message #540828] Thu, 26 January 2012 00:48 Go to previous messageGo to next message
Littlefoot
Messages: 19887
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
                        )
Re: Master detail form [message #540977 is a reply to message #540829] Thu, 26 January 2012 17:17 Go to previous message
deepu2022
Messages: 5
Registered: January 2012
Location: USA
Junior Member
Thanks alot guys! I used the above logic to fix it.
Previous Topic: SENDING EMPLOYEE PAYROLL SLIP
Next Topic: what are the parameters for app_window.set_window_position()
Goto Forum:
  


Current Time: Fri Dec 19 03:30:56 CST 2014

Total time taken to generate the page: 0.11340 seconds