Re: Count the related records of a found set

From	Lynn Allen <lynn@NOT-semiotics.com>
Organization	What?
Newsgroups	comp.databases.filemaker
Date	2011-07-03 10:47 -0700
Message-ID	<4e10ab20@news.bnb-lp.com> (permalink)
References	<1k3trsb.1t7bmm5s0xis2N%clk@tele2.ch>
Subject	Re: Count the related records of a found set

Show all headers | View raw

On 2011-07-03 01:32:10 -0700, clk@tele2.ch (Christoph Kaufmann) said:

> 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.

I'd use Go To Related Records, select the Match Found Set option, then 
use Get(FoundCount) to set the value into a variable, after the GTRR. 
Then return to the original child record set.
-- 
Lynn Allen
--
www.semiotics.com
Member FBA
FM 10 Certified Developer

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