From: Lynn Allen Organization: What? Newsgroups: comp.databases.filemaker Date: Sun, 3 Jul 2011 10:47:15 -0700 Message-ID: <4e10ab20@news.bnb-lp.com> 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 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