Re: Count the related records of a found set

From	Lynn Allen <lynn@NOT-semiotics.com>
Organization	What?
Newsgroups	comp.databases.filemaker
Date	Sun, 3 Jul 2011 10:47:15 -0700
Message-ID	<4e10ab20@news.bnb-lp.com> (permalink)
References	<1k3trsb.1t7bmm5s0xis2N%clk@tele2.ch>
MIME-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	8bit
Subject	Re: Count the related records of a found set
User-Agent	Unison/1.7.9
NNTP-Posting-Host	pool-74-100-83-23.lsanca.fios.verizon.net
X-Trace	news.bnb-lp.com 1309715232 pool-74-100-83-23.lsanca.fios.verizon.net (3 Jul 2011 13:47:12 -0400)
Lines	19
X-Authenticated-User	vca037
X-DMCA-Complaints	Send abuse or DMCA complaints to abuse@bnb-lp.com
X-DMCA-Complaints	The subject line should contain only the 4 letters DMCA
Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!news.swapon.de!feedme.ziplink.net!border4.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.bnb-lp.com!not-for-mail
Xref	x330-a1.tempe.blueboxinc.net comp.databases.filemaker:295

Show key headers only | 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