Re: Count the related records of a found set

Newsgroups	comp.databases.filemaker
Subject	Re: Count the related records of a found set
From	clk@tele2.ch (Christoph Kaufmann)
Date	Mon, 4 Jul 2011 22:14:29 +0200
Message-ID	<1k3wixy.kmxhd11k1g1tsN%clk@tele2.ch> (permalink)
References	<1k3trsb.1t7bmm5s0xis2N%clk@tele2.ch> <4e10ab20@news.bnb-lp.com> <1k3un2t.jebjorjag4sN%clk@tele2.ch> <iusk7h$ac$1@news.motzarella.org>
Organization	CLK.ch
User-Agent	MacSOUP/D-2.8.3 (Mac OS X version 10.6.8 (x86))
Lines	10
NNTP-Posting-Host	62.167.123.27
X-Trace	1309810470 news.sunrise.ch 4015 62.167.123.27:6538
X-Complaints-To	abuse@sunrise.ch
Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!feed.ac-versailles.fr!news.in2p3.fr!in2p3.fr!kanaga.switch.ch!switch.ch!newsfeed-du-01.pub.2nd.sunrise.ch!not-for-mail
Xref	x330-a1.tempe.blueboxinc.net comp.databases.filemaker:306

Show key headers only | View raw

Howard Schlossberg <howard@nospam.fmprosolutions.com> wrote:

> But another way would be to use the List() function to get all 
> ParentID's from the child table.  Then use a valuecount() of 
> UniqueValues() to determine the number of unique parent IDs.

Great. It's like Helpful Harry's approach, enriched with the list
function that doesn't exist in v5.5 :-)
-- 
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