Re: Count the related records of a found set

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!kanaga.switch.ch!switch.ch!newsfeed-du-01.pub.2nd.sunrise.ch!not-for-mail
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 06:18:55 +0200
Message-ID	<1k3vanu.1txv9x58zgabkN%clk@tele2.ch> (permalink)
References	<1k3trsb.1t7bmm5s0xis2N%clk@tele2.ch> <yourname-0407110916160001@203-118-185-113.dsl.dyn.ihug.co.nz>
Organization	CLK.ch
User-Agent	MacSOUP/D-2.8.3 (Mac OS X version 10.6.8 (x86))
Lines	24
NNTP-Posting-Host	84.227.254.250
X-Trace	1309753135 news.sunrise.ch 4013 84.227.254.250:12090
X-Complaints-To	abuse@sunrise.ch
Xref	x330-a1.tempe.blueboxinc.net comp.databases.filemaker:304

Show key headers only | View raw

Your Name <yourname@yourisp.com> wrote:

Create a Relationship in the child table to group the related records.
> e.g.
>       rel_SameParent
>       match record in ChildTable with records in ChildTable
>       when ParentKey = ChildTable::ParentKey


Sounds great.

> Another way would be to create some fields in the Parent Table.
> 
> Create a Calculation Field to "flag" if there are any related Child Table
> records.
> e.g.
>       HasChildRecords     Calculation, Number Result, Unstored
>           = If(Count(rel-ChildTable::KeyField) > 0; 1; 0)

The result wouldn't depend on the found set in the child table, I stick
to the first version.

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