Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!titan!drack
From: drack@titan.tsd.arlut.utexas.edu (Dave Rackley)
Newsgroups: comp.databases
Subject: SQL*Forms V3.0 -- Multiple detail relations?
Message-ID: <DRACK.90Oct17081418@diablo.titan.tsd.arlut.utexas.edu>
Date: 17 Oct 90 13:14:18 GMT
Sender: news@titan.tsd.arlut.utexas.edu
Distribution: comp.databases
Organization: Applied Research Laboratories, University of Texas at Austin.
Lines: 30

While experimenting with SQL*Forms v3.0, I came across what appears to be a
limitation or bug.  The situation follows:

        --  A master table with 10 fields.

	--  Two detail tables with 2 fields each.

        --  The master and detail tables share a common key field.

	--  For each key value one detail table has approximately 10 times 
            the records the second detail table.

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?

The real question is:  Has anyone else experienced this shortcoming?


Thanks in advance. 
--

  DISCLAIMER?  I don't know anything 'bout any ol' disclaimer!         

+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
| David Rackley		        |                                             |
| Applied Research Laboratories |        Remember, you can tuna fish,         |
| The University of Texas       |         But you can't tuna piano!           |
| Austin, TX.  78758            |                                             |
+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+