Home » Developer & Programmer » Forms » new canvas pulling from child to parent (merged 3) 10g
new canvas pulling from child to parent (merged 3) 10g [message #416289] Fri, 31 July 2009 08:30 Go to next message
tuckersuz
Messages: 26
Registered: July 2009
Junior Member
Hello:

I need to create a canvas that will pull records from a child table. There is a parent block, then a child block. I have another block that is another parent to the existing child block, but I need the 2nd parent to pull records based on the existing child block.
example:

Issues (parent)
Issue failures (child)
Other issues (2nd parent)

So, what I would like is for the Other issues to populate based on what the Issue Failures pulls. I know I need some type of reverse query, so any help would be GREATLY appreciated.

Many thanks

Report message to a moderator

Re: new canvas pulling from child to parent (merged 3) 10g [message #416426 is a reply to message #416289] Sun, 02 August 2009 05:15 Go to previous message
cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester
Senior Member
Unless you want to query Issue failures based on Other issues, and it appears you don't, then as far as this form is concerned Other Issues isn't really parent and can be treated as a child.
I suspect a simple relationship between the two is all you need.

Report message to a moderator

Previous Topic: userenv command
Next Topic: oracle forms (merged 2) 6.0i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 08 07:34:30 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.