OraFAQ Forum: Forms » Master Detail Form (Wrong Data)

Home » Developer & Programmer » Forms » Master Detail Form (Wrong Data) (Windows Vista, Oracle 11g, Form Builder 6i)

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

Master Detail Form (Wrong Data) [message #523929]

Wed, 21 September 2011 03:29

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Hi Experts,

I've a Master-Detail Form.

Recently I started entering data in detail part of the form.

The number of records I enter in detail part of the form the master part is repeated for same number of records.

For example if a master record consist of 3 detail records the master record will be repeated for 3 times. But in back-hand (data base) correct actual records exist.

Please help me to resolve this issue.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523931 is a reply to message #523929]

Wed, 21 September 2011 03:37

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

Senior Member
Account Moderator

I read what you said several times, but I don't understand what you have (OK, a master-detail form) and what is the problem.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523933 is a reply to message #523931]

Wed, 21 September 2011 03:42

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Master Block has 1 record
Detail Block has 3 records

Form displays Master record for 3 times because it has 3 detail records.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523935 is a reply to message #523933]

Wed, 21 September 2011 03:55

Baranor
Messages: 83
Registered: September 2011
Location: Netherlands

Member

Sounds like your key (relation) in Forms isn't quite right. If you switch from one master record to another, does the detail block get updated?

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523941 is a reply to message #523935]

Wed, 21 September 2011 04:08

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

Senior Member
Account Moderator

Did you let Wizard create relationship, or did you do it manually? Perhaps you should delete all existing code (triggers, procedures) and ask Wizard to do it properly.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523949 is a reply to message #523941]

Wed, 21 September 2011 04:46

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

I've re-created relation by manually and by wizard, still facing the same problem.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523950 is a reply to message #523935]

Wed, 21 September 2011 04:49

Baranor
Messages: 83
Registered: September 2011
Location: Netherlands

Member

Baranor wrote on Wed, 21 September 2011 03:55

Sounds like your key (relation) in Forms isn't quite right. If you switch from one master record to another, does the detail block get updated?

See above... could you answer that for me? Without a specific description, its hard to tell whats going on.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523964 is a reply to message #523950]

Wed, 21 September 2011 05:32

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

yes it is.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523968 is a reply to message #523964]

Wed, 21 September 2011 05:38

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

What are the tables? What is the relationship between them?

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523976 is a reply to message #523968]

Wed, 21 September 2011 05:58

Baranor
Messages: 83
Registered: September 2011
Location: Netherlands

Member

You based your master block on a view? If so, try selecting the same data from that view... because either your view displays more records than it should, or your key-link is bad.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #523999 is a reply to message #523976]

Wed, 21 September 2011 06:26

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Att. Cookiemonster
Relation : one to many

Att. Baranor
No master block not on a view.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #524018 is a reply to message #523999]

Wed, 21 September 2011 06:56

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Look - you've done something wrong.
Since we know nothing about the tables or the relationship between or what you've told forms the relationship is, we have no idea how to fix it.
So you need to give a lot more details.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #524132 is a reply to message #524018]

Thu, 22 September 2011 00:30

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Detail block consist on stack canvas.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #524133 is a reply to message #524132]

Thu, 22 September 2011 00:41

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

Senior Member
Account Moderator

Cool, but I'm afraid that this is not the cause of your problems.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #524164 is a reply to message #524133]

Thu, 22 September 2011 01:54

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

I found it.
In property pallet of master block
In clause of Query data source name (I mistakenly included the detail table)
And in Where clause (I mistakenly included the detail table join)
By removing the table and join from above two clauses, now it is working well.
Thanks for your support.

Report message to a moderator

Re: Master Detail Form (Wrong Data) [message #524165 is a reply to message #524164]

Thu, 22 September 2011 01:56

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

Senior Member
Account Moderator

Great news! Thank you for letting us know.

Report message to a moderator

Previous Topic:	Run Report from Form10g
Next Topic:	Restriction on new record addtion in datablock through form menu plus icon

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:04:08 CDT 2024