Re: Developper 2000 master/detail
Date: 14 May 2004 05:45:55 -0700
Message-ID: <77459c6d.0405140445.34e07b74_at_posting.google.com>
> 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:)
[Quoted] 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_Cisailleur10- 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
Received on Fri May 14 2004 - 14:45:55 CEST