FMP 11 : problem with a portal

[dodds]

In the GestionEcole_23.fp7 joined file let us consider in Browse mode  the INS_Liste Table modelayout which displa the INS table records : there are 14 records.

Consider now the INS_Fiche Form mode layout : no surprise, there are also 14 records.
Bur switch to Layout mode and look at any field, except the Zkc_Annee field : this fields is not drawn from the INS table but from the TO  ins_PER__Eleve, double-linked to the INS table :
Zkf_PER(INS) = Zkp (PER)
Zkk_Eleves(INS) = Type(PER)
Zkk_Eleves contains the constant character string "élève".
11 PER records have a Type field which contains this text, so I expected to get only 11 records, but in fact 14 records are displayed, with 3 records containing every field empty, except the Zkc_Annee field.
Why this anomaly ?

GestionEcole_23.fp7.zip

[Wim Decorte]

What you are seeing is correct.

 

The "fiche" layout uses the INS_PER_eleves relationship,  So it does not show data for the last 3 records because those records are not of type "eleve"

The "liste" layout uses the INS_PER relationship, so it shows all related data from the PER table, not just that for the "eleves"

 

The number of records show is never going to change only based on the relationship, you should not expect that.  The data that is displayed on those records can vary depending on the relationships you use on each layout.

[dodds]

Wim, thanks a lot for your answer, because I had lost any hope to find an answer on these two French forums, yet usually relatively active :

- https://fmdpev.filemaker.com/message/119284#119284
- http://www.fmsource.com/index.php/topic/50210-bizarrerie-enregistrements-vides/
As you have probably guesseed I am French, living in Paris.
Consequently, I met some difficulties to build a generic English description of my problem, in order for this description to be easily understood by Anglo-American people, omittiong to describe tthe logical mission of each table.

By the way, very oftenn, I remarked that it was very difficult to understand a FMP file architecture without knowing the real goal of the file.
In this case, I apparently succeeded.
So, OK, this part of your answer is a total surprise for me :

 

The number of records show is never going to change only based on the relationship, you should not expect that.  The data that is displayed on those records can vary depending on the relationships you use on each layout.

Il I understand, that means that on a view based on the anchor table INS, which counts 14 recordings, whatever be the portal using INS as anchor table and added on this view, this portal will display 14 records ?
I auto trained myself with FileMaker Training Series and FileMaker_Pro_11_The_Missing_Manual, I didn't catch this rule : could you give me a reference giving this rule ?