Re: forms 4.0 relation doesn't work!

In article <43a0em$7f0_at_butch.lmsc.lockheed.com>, e247523_at_l10a.decnet.lockheed.com says...
>
>A few days ago I posted a request for help with a problem with Oracle
>Forms 4.0. I have one parent table and several child tables with a
>common field. I tried to make a form that would display the parent
>table as well as the child tables. I created a block for each table and
>used the master/detail for the child table blocks. When I run the form
>and do a query, I only get the parent block filled in.
>
 ...
>
>
>Damon

Oracle Forms uses 3 different methods for coordinating between master and detail blocks: Deffered with no auto-query, Deferred with auto-query and Immediate. In the first case, you have to manually navigate to a detail block and execute a query (via key press or 'EXECUTE-QUERY'), in the second case, data for the block is fetched as soon as you navigate into the block and only in the third ('Immediate') case, all detail blocks are filled, as soon as the master block is filled. The last case is what you want, so verify, that all the relations have 'Deferred' unchecked!

Also the Join condition for all the relations should only contain 'rea_no' or (for example) 'rea.rea_no = harness.rea_no'.

Guenter

Guenter Gersdorf                         Phone:      +49/(0)531/391-7634
Inst. f. Werkzeugmaschinen               Fax:                      -5842
und Fertigungstechnik, TU Braunschweig   E-Mail:     G.Gersdorf_at_tu-bs.de