Home » Developer & Programmer » Forms » Master Detail form storing multiple records
Master Detail form storing multiple records [message #593012] Tue, 13 August 2013 09:49 Go to next message
sumanthllr
Messages: 15
Registered: April 2013
Junior Member
Hi,

I am new to the Oracle Forms.
I need a Master Detail oracle form for Oracle EBS.
The form should use only one table.
I need the form should look like User Form in EBS.
I created 2 data blocks and designed. When I run the form and key in some data, I notice multiple records stored.

like

Empno   Ename   Sal   Comm 
101     null    null  null
null    John    2300   500

Empno is in Master Block.
And remaining are in Detail block.

Anybody suggest me how to remove the duplicate records so that my required output should be like
Empno   Ename   Sal   Comm 
101     John    2300   500

If there is another way suggest me ...
Re: Master Detail form storing multiple records [message #593046 is a reply to message #593012] Tue, 13 August 2013 13:10 Go to previous messageGo to next message
joy_division
Messages: 4515
Registered: February 2005
Location: East Coast USA
Senior Member
How can you have a master detail with only one table?
In any event, you cannot have a master detail without a linking column, of which you have none based on the 2 rows that you show.
Re: Master Detail form storing multiple records [message #593071 is a reply to message #593046] Tue, 13 August 2013 19:55 Go to previous messageGo to next message
sumanthllr
Messages: 15
Registered: April 2013
Junior Member
Thanks for the reply.

Let me explain you.
Ex:-
I have a table with 4 columns.

Type    column1     column2     column3


Actually my requirement is the form should look like

Type   _______

Column1      Column2       Column3
_______      _______       _______
_______      _______       _______
_______      _______       _______
_______      _______       _______


So, thats why I told that the form should look like Oracle User Form.
Here I used 2 data blocks its because of to repeat the three columns 4 times.
Any alternative for this?

Re: Master Detail form storing multiple records [message #593107 is a reply to message #593071] Wed, 14 August 2013 03:05 Go to previous messageGo to next message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
Create a view that presents the data in the correct format then base the block on that
Re: Master Detail form storing multiple records [message #593124 is a reply to message #593107] Wed, 14 August 2013 07:09 Go to previous messageGo to next message
sumanthllr
Messages: 15
Registered: April 2013
Junior Member

I didn't get you.
Can you please elaborate in detail
Re: Master Detail form storing multiple records [message #593134 is a reply to message #593071] Wed, 14 August 2013 08:27 Go to previous message
joy_division
Messages: 4515
Registered: February 2005
Location: East Coast USA
Senior Member
ashok_524 wrote on Tue, 13 August 2013 20:55

Type   _______

Column1      Column2       Column3
_______      _______       _______
_______      _______       _______
_______      _______       _______
_______      _______       _______


Any alternative for this?


One multi-record block and set the number of items displayed property of TYPE to 1.
You will then have to find a way to populate TYPE for all additional records. There are many trivial ways to do that.
Previous Topic: Cusrsor Control in FIND box when LOV invoked
Next Topic: Populate data block
Goto Forum:
  


Current Time: Sat Sep 20 19:51:38 CDT 2014

Total time taken to generate the page: 0.05257 seconds