Re: Count the related records of a found set

From	cortical <cb@corticaldata.com.au>
Newsgroups	comp.databases.filemaker
Subject	Re: Count the related records of a found set
Date	2011-07-04 11:41 +0930
Organization	Aioe.org NNTP Server
Message-ID	<iur7fq$rrh$1@speranza.aioe.org> (permalink)
References	<1k3trsb.1t7bmm5s0xis2N%clk@tele2.ch>

Show all headers | View raw

On 3/07/11 6:02 PM, Christoph Kaufmann wrote:
> FMP 10 Adv: I have 20'000 records with some 15'000 parents - what's the
> best way to count the number of parents of my present found set in the
> child table?
>
> The count function returns 1 for every single record, the sum will be
> the number of child records, i.e. the number of records in my found set.
>

Create a rel from child to parent using Child:parent_id to Parent::parent_id

create a value list based on the rel, then something like this: Count 
the value list items;


set  $_child_parents =


ValueCount ( ValueListItems ( Get ( FileName ) ; "child_parents" ))

or more elegantly:

Let([
F = Get ( FileName ) ;
VL = "child_parents" ;
VLI = ValueListItems ( F ; VL )
];
ValueCount ( VLI )
)

Back to comp.databases.filemaker | Previous | Next — Previous 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