Path: utzoo!attcan!uunet!seismo!dimacs.rutgers.edu!mips!daver!kcdev!genco!rad
From: rad@genco.uucp (Bob Daniel)
Newsgroups: comp.databases
Subject: Re: SQL*Forms V3.0 -- Multiple detail relations?
Message-ID: <79@genco.uucp>
Date: 18 Oct 90 14:36:16 GMT
References: <DRACK.90Oct17081418@diablo.titan.tsd.arlut.utexas.edu>
Reply-To: rad@genco. (Bob Daniel)
Distribution: comp.databases
Organization: Gentry & Assoc. Excelsior Springs, MO
Lines: 12

In article <DRACK.90Oct17081418@diablo.titan.tsd.arlut.utexas.edu> drack@titan.tsd.arlut.utexas.edu (Dave Rackley) writes:
>The questions:  Is SQL*Forms v3.0 limited to one master, one detail relation;
>                if not, what is the secret incantation (trigger) that allows
>                retrieval and display of the forms data?

One CAN have more than one master-detail relation but have to define the
join condition under DEFAULT block setup. 

1) First define the master block.
2) Then define the detail block using DEFAULT and use a join condition on a
   keyed field in both tables.  
3) To apply another detail block, repeat the second step.