Re: Developper 2000 master/detail
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 14 May 2004 23:00:45 +0200
Message-ID: <c83bqt$bqm$1_at_news1.tilbu1.nb.home.nl>
>
>
> Here are both tables
>
> Table1_Name = Parametres_Cisailleur
> Name Null? Type
> ------------------------------- -------- ----
> CYCLE VARCHAR2(3)
> ITEM NUMBER(5,1)
> VITESSE_DEMELEUR NUMBER(4)
> SAUT_REGULIER NUMBER(2)
> SAUT_SPECIAUX NUMBER(2)
> NB_PAQUET_ENTRE_SAUT_SPECIAUX NUMBER(2)
> SAUT_ACTUEL NUMBER(2)
>
> Table2_Name = Commande
> Name Null? Type
> ------------------------------- -------- ----
> CYCLE VARCHAR2(3)
> ITEM NUMBER(5,1)
> DIMLAM VARCHAR2(11)
>
> Here are the steps I did to create the form
>
> 1- Tools --> New block
> 2- base table --> Parametres_Cisailleur
> 3- Select all rows from Parametres_Cisailleur
> 4- click OK button
> 5- tools --> New block
> 6- base tabel --> commande
> 7- select all rows from commande
> 8- go to master/detail page
> 9- master block --> Parametres_Cisailleur
> 10- join condition =
> Parametres_Cisailleur.item = commande.item and
> Parametres_Cisailleur.cycle = comande.cycle
> 11- click ok button
> 12- I set block1 and block2 properties --> records displayed 10
>
> When I run form, I press F7 then F8 to execute query.
> I get block1 "Parametres_Cisailleur" populated with all
> records from table and block2 "Commande" is only populated for
> line 1 of block1 "Parametres_Cisailleur". If I scroll down in records,
> only line 1 of block2 "Commande" changes. What should hapen is that
> where there's a record for block1 a value from block2 should be at same row.
>
> P.S. There's a corresponding record in table commande for each
> record in table Parametres_Cisailleur. The relation between the two tables
> is cycle and item.
>
> Thanks!
> Curtis
Date: Fri, 14 May 2004 23:00:45 +0200
Message-ID: <c83bqt$bqm$1_at_news1.tilbu1.nb.home.nl>
Curtis wrote:
>>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:)
>
>
> Here are both tables
>
> Table1_Name = Parametres_Cisailleur
> Name Null? Type
> ------------------------------- -------- ----
> CYCLE VARCHAR2(3)
> ITEM NUMBER(5,1)
> VITESSE_DEMELEUR NUMBER(4)
> SAUT_REGULIER NUMBER(2)
> SAUT_SPECIAUX NUMBER(2)
> NB_PAQUET_ENTRE_SAUT_SPECIAUX NUMBER(2)
> SAUT_ACTUEL NUMBER(2)
>
> Table2_Name = Commande
> Name Null? Type
> ------------------------------- -------- ----
> CYCLE VARCHAR2(3)
> ITEM NUMBER(5,1)
> DIMLAM VARCHAR2(11)
>
> Here are the steps I did to create the form
>
> 1- Tools --> New block
> 2- base table --> Parametres_Cisailleur
> 3- Select all rows from Parametres_Cisailleur
> 4- click OK button
> 5- tools --> New block
> 6- base tabel --> commande
> 7- select all rows from commande
> 8- go to master/detail page
> 9- master block --> Parametres_Cisailleur
> 10- join condition =
> Parametres_Cisailleur.item = commande.item and
> Parametres_Cisailleur.cycle = comande.cycle
> 11- click ok button
> 12- I set block1 and block2 properties --> records displayed 10
>
> When I run form, I press F7 then F8 to execute query.
> I get block1 "Parametres_Cisailleur" populated with all
> records from table and block2 "Commande" is only populated for
> line 1 of block1 "Parametres_Cisailleur". If I scroll down in records,
> only line 1 of block2 "Commande" changes. What should hapen is that
> where there's a record for block1 a value from block2 should be at same row.
>
> P.S. There's a corresponding record in table commande for each
> record in table Parametres_Cisailleur. The relation between the two tables
> is cycle and item.
>
> Thanks!
> Curtis
Did not follow all of the thread, but a master-detail form where the
master is to display 10 records?!? Sounds like many masters to
many (one?) details...
What 's the foreign key definition ( that is: which way around is
the relation?)
-- Regards, Frank van BortelReceived on Fri May 14 2004 - 23:00:45 CEST