Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Forms 4.5 - Help!

Re: Newbie Forms 4.5 - Help!

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Wed, 5 Aug 1998 13:48:23 +0100
Message-ID: <6q9ka3$cv5$1@schbbs.mot.com>


Yes, the relationship will onyl query child records fro the current record and not for all those displayed in Forms4.5.

As I understand it you have three tables all effectively linked one to one. Why do you not attack the problem from a database perspective rather than from a Forms4.5 perspective. Create a view across the three tables (possibly using outer joins as necessary) and then simply create one block in your form for the view.

Of course, this is only good for retrieving data. You won't be able to create new records.

HTH a little

--
Alan D. Mills

Daniel Cohen wrote in message
<01bdc05d$730f0e60$eb58ea9e_at_ukp016543.logica.co.uk>...
>
>I have data from 3 tables which all need to be displayed on one form.
>
>Two of the tables are linked on a one to one basis by a reference id, and
>the third is linked on a one to one with the second table using another
>key.
>
>I have started by trying to link 2 tables and have established the link
>using a master detail relationship. However, in the second table block,
>data is only displayed on the top line instead of over the 10 records
>defined in the block. Help!
>
>
Received on Wed Aug 05 1998 - 07:48:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US