Re: Developper 2000 master/detail

"Curtis" <cmarchand_at_norambar.ca> schrieb im Newsbeitrag news:77459c6d.0405130800.2dacbe1c_at_posting.google.com...
> "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:<2ggm42F2hpa1U1_at_uni-berlin.de>...
> > "Curtis" <cmarchand_at_norambar.ca> schrieb im Newsbeitrag
> > news:77459c6d.0405120408.1329ba2_at_posting.google.com...
> > > Hi I'm using Dev2000 designer
> > >
> > > Forms [32 Bit] Version 4.5.10.6.0 (Production)
> > > Oracle Toolkit Version 2.3.7.2.0 (Production)
> > > PL/SQL Version 1.2.5.0.5 (Production)
> > > Oracle Procedure Builder V1.5.8.0.0 - Production
> > > Oracle Virtual Graphics System Version 2.1.12.9.0 (Production)
> > > Oracle Tools GUI Utilities Version 1.2.4.0.0 (Production)
> > > Oracle Multimedia Version 2.0.8.1.0 (Production)
> > > Oracle Tools Integration Version 1.2.1.6.0 (Production)
> > > Oracle Tools Common Area Version 2.0.5.0.0
> > > Oracle CORE Version 4.0.3.0.0 - Production
> > >
> >
> > Now, *that* is the kind of background info we need - You are a real
Vorbild
> > 8)
> >
> > OK: Generally, Forms 4.5 is outdated for ages; 5 is also antiquated, 6i
is
> > the last Version
> > supporting Client/Server. 7 or 8 never existed, 9i only supports 3-tier
with
> > a browser.
> >
> > > and I'm trying to get block2 that as join condition with block1 to
> > > fill multi-record block2 according to multi-record block1.
> > > Block2 has block1 as master block with join condition
> > > I get only 1 record in block2 that changes when I scroll
> > > thru block1.
> > >
> > > Ex.: Block1 Block2
> > > record1 Name Family_Name
> > > record2 Name
> > > record3 Name
> > >
> > > Record1 Block2 Changes when I go to record2
> > > record2 block2 should be populated after query but it is not
> > >
> > > I wonder if this is the right way to approach this?
> >
> > So far: yes. But maybe the direction of the M-D relationship should be
> > opposite ?
> > That is what it sounds and looks like ... 1 Family_Name : N Names ...
> > Check also the data model in the database (FKs etc).
> >
> > hth, Jan
>
> Nope , same thing.
> No madder direction of relationship block2 only displays 1 record even
> thow displayed record is 10 like block 1.
> Only record 1 of block2 changes.
>
> Curtis

[Quoted] Did You create the 2 blocks with the Data Block Wizard (well, I do not recall if it was available in 4.5) ?
At least from 5 and higher on, the Wizard did the things fro You, and the only thing to check for
is the proper mapping of the relationship of the database to the blocks. One may be unhappy
with wizards, but they are always the best first step to my view.

Maybe You could show us the tables, the FK and also and some example data from the database,
using Sql*plus ? In the end, it could also be the data ...

Jan:) Received on Fri May 14 2004 - 07:55:38 CEST