OraFAQ Forum: Forms » Master Detail form storing multiple records

Home » Developer & Programmer » Forms » Master Detail form storing multiple records

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

Master Detail form storing multiple records [message #593012]

Tue, 13 August 2013 09:49

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 ...

Report message to a moderator

Re: Master Detail form storing multiple records [message #593046 is a reply to message #593012]

Tue, 13 August 2013 13:10

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Master Detail form storing multiple records [message #593071 is a reply to message #593046]

Tue, 13 August 2013 19:55

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?

Report message to a moderator

Re: Master Detail form storing multiple records [message #593107 is a reply to message #593071]

Wed, 14 August 2013 03:05

cookiemonster
Messages: 13920
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

Report message to a moderator

Re: Master Detail form storing multiple records [message #593124 is a reply to message #593107]

Wed, 14 August 2013 07:09

sumanthllr
Messages: 15
Registered: April 2013

Junior Member

I didn't get you.
Can you please elaborate in detail

Report message to a moderator

Re: Master Detail form storing multiple records [message #593134 is a reply to message #593071]

Wed, 14 August 2013 08:27

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Cusrsor Control in FIND box when LOV invoked
Next Topic:	Populate data block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:29:16 CDT 2024