Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #304

Re: Count the related records of a found set

Show all headers | 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