Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #305

Re: Count the related records of a found set

Show all headers | View raw

On 7/3/2011 9:04 PM, Christoph Kaufmann wrote:
> Lynn Allen<lynn@NOT-semiotics.com>  wrote:
>
>> 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.
>
> Thanks - I thought as much. I take it there's no way to calculate the
> number then.


I would probably do it the same a Lynn.

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.

You'll find the UniqueValues() function at 
http://www.briandunning.com/cf/596

So your calc would end up looking something like this:
	ValueCount( UniqueValues( List( Children::ParentID )))

The only problem with this method is that it might be slow across 20,000 
records, whereas it might be just fine across 1000 records.

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