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
Messages: 26
Registered: July 2009
Junior Member

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.

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
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
Messages: 12820
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.
Previous Topic: userenv command
Next Topic: oracle forms (merged 2) 6.0i
Goto Forum:

Current Time: Fri Aug 18 15:13:32 CDT 2017

Total time taken to generate the page: 0.06914 seconds