FMPro Cannot display N records from different table/File

[Rramjet]

This is a problem I ran across a couple of years ago but sidestepped by including all fields in one table - but that is not possible in this instance. It seems a MOST basic thing to ask FM to do - so why can't it?

I want FM to display the number of records in a related child table(s) on a LO in the Parent table - but it just will not do it!

To provide the simplest example: I have two related tables (Parent and Child related by serial number fields: P_SRN = C_SRN). The Child contains more records than the parent (due to duplications for re-admissions). I have a field (C_N as a summary count of C_SRN) displaying the number of records in the child table (easy peasy). I also have C_Isvalid_Indicator field as a calculation field (Case(IsValid(C_SRN); 1)) and then (also - as a different method of ding the same thing) C_N_2 as a calculation field (Count(C_IsValid_Indicator))...

Now...in the parent table, I have tried directly displaying either "N" field (C::C_N or C::C_N_2) but this either returns a value in the parent only when the viewed record is valid in the child (otherwise 0 or blank). I have tried creating a field in the parent and then a Lookup. I have tried various calculations in the Parent using functions (Count, Get, etc) but nothing works to get the number of records in the child to display in the parent across all records in the parent.

Help please?

[comment]

I am not sure what you mean by "display across all records in the parent". If you define a calculation field in the Parent table as Count ( Child::Matchfield ), it will display the number of children of each parent, and it will do so across all records in the Parent table.

If you want to also show the total number of children, you can do this in a number of ways, for example:

• define a summary field in the Parent table as Total of the above calculation field (this will show the total number of children of parents in the current found set);

• define an unstored calculation field in the Child table as Get (TotalRecordCount), and place it on the layout of Parent (this will show the total number of records in the Child table).

[Rramjet]

Thank you, this was driving me bananas! I knew there HAD to be a solution somewhere...

Your second solution seems most parsimonious and represents exactly what I needed

In appreciation,

Rramjet.

Edited August 14, 2009 by Guest

[comment]

most parsimonious

I prefer "elegant"... ???

[Rramjet]

Ah yes... the right word in the right place

Cheers :thumbup: