Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #307

Re: Count the related records of a found set

Show all headers | View raw

Helpful Harry wrote:

> Create a Relationship in the child table to group the related records.
> e.g.
>       rel_SameParent
>       match record in ChildTable with records in ChildTable
>       when ParentKey = ChildTable::ParentKey
> 
> Then you can create a Calculation Field which works out each record being
> 1/xth of the total number of same parent records.
> e.g.
>      OneXth      Calculation, Number Result, Unstored
>         = 1 / Count(rel_SameParent::ParentKey)
> 
> If you were to then create a Summary Field and Summary Report totalling
> these values, you would get a total of 1 for each different ParentKey
> sub-summary. Which also means to get the number of unique parent records
> you can simply summarise them all
> e.g.
>      s_NumParentRecords    Summary
>           Total of OneXth

I'm afraid that this method, too, works only if I have every record of
the table in the found set, because the totalling depends on the found
set, the count of the child records with the same parent, however, does
not.
-- 
http://clk.ch

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Count the related records of a found set clk@tele2.ch (Christoph Kaufmann) - 2011-07-03 10:32 +0200
  Re: Count the related records of a found set Lynn Allen <lynn@NOT-semiotics.com> - 2011-07-03 10:47 -0700
    Re: Count the related records of a found set clk@tele2.ch (Christoph Kaufmann) - 2011-07-04 06:04 +0200
      Re: Count the related records of a found set Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2011-07-04 07:54 -0700
        Re: Count the related records of a found set clk@tele2.ch (Christoph Kaufmann) - 2011-07-04 22:14 +0200
          Re: Count the related records of a found set Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2011-07-05 10:26 -0700
  Re: Count the related records of a found set yourname@yourisp.com (Your Name) - 2011-07-04 09:16 +1200
    Re: Count the related records of a found set clk@tele2.ch (Christoph Kaufmann) - 2011-07-04 06:18 +0200
    Re: Count the related records of a found set clk@tele2.ch (Christoph Kaufmann) - 2011-07-05 14:21 +0200
      Re: Count the related records of a found set yourname@yourisp.com (Your Name) - 2011-07-06 09:22 +1200
  Re: Count the related records of a found set cortical <cb@corticaldata.com.au> - 2011-07-04 11:41 +0930

csiph-web