Re: FORMS 4.0 Relation Problem

From: kenneth d atkins, s=david m thomas <Kenneth.D.Atkins_at_tek.com>
Date: 24 Jan 1995 22:45:14 GMT
Message-ID: <3g3vtq$dss_at_goodnews.wv.tek.com>

Assuming you have a structure like this:

Table_A         Table_B         Table_C
-------         ---------       -----------     
A_ID            A_ID            B_ID
Other Cols      B_ID            C_ID
               Other Cols      Other cols
               .               .
               .               .

You could add something like the following to the where clause in the block based on Table C:

WHERE B_ID IN (SELECT B_ID FROM TABLE_B                WHERE A_ID = :A_BLOCK.A_ID) This is the same sort of thing that had to be done in 3.0 (or 2.3 for that matter). It may be kind of slow, depending on your data, but if your keys are unique numbers it should be fast enough.

I have not worked with 4.0 long enough to know if there is some slick 4.0 way to do the same thing.

---

Kenneth Atkins (Financial Data Systems Inc.) Email: Kenneth.D.Atkins_at_Tek.com

---

Ken Brouillette <kabroui_at_envc.sandia.gov> wrote:

>

> Hi.
> I have a question concerning a relationship I am trying to build
> in Forms 4.0. I have three tables A, B, C. A is a master-detail to
> B and B is a master-detail to C. I want to be able to query all of
> the records in C associated with a user selected record in A without
> having those records subsetted by the key in B.Is there a way to
> do this in Forms without actually creating a foreign key relationship between
> between A and C? Any ideas greatly appreciated.
>
> Ken
> kabroui_at_envc.sandia.gov
  Received on Tue Jan 24 1995 - 23:45:14 CET