Relationship for subsummary data

[d_roderick]

Hi All,

I'm quite rusty with Filemaker and having trouble with the following:

I have 2 database files.

1. ENTRANTS

2. CODES

Entrants has about 1,000 records. The records have a field named CLASS. CLASS is a related field that pulls up information in the CODES Database. I want to display a count of all Classes in a different database file. The new file will be called TASTE.

e.g.

record 1 - CLASS 120

record 2 - CLASS 100

record 3 - CLASS 120

record 4 - CLASS 100

record 5 - CLASS 150

sub summary results yield

CLASS 100 - 2

CLASS 120 - 2

CLASS 150 - 1

There should be one record in the TASTE database for each record in the CODES database. I want to pull the sub-summary information into the TASTE database. Having difficulty getting my head around this. Many thanks in advance.

d

[Søren Dyhr]

The summary should preferably be done in the "many" section of relation, and then pulling data from the "one" side ... when I say preferably is it because you sometimes wish to have counts of zero...

--sd

[innodat]

You can count related records based on your relationship with Count(RemoteField).

Let's assume that you already have a Taste record for each possible class in your TASTE file. Let's further assume that the name of the class is stored in a field called ClassName in the TASTE table. Let's also assume that you have a Record ID field in both tables (serial number, auto entry).

You should now be able to create a relationship with the following key fields:

TASTE::ClassName = CLASS::Name

Then all you need is a calculation in the TASTE table:

TASTE::ClassName & " - " & Count (AboveRelationship::RecordID)

[Søren Dyhr]

I wouldn't advice this way without knowing the measure of records attempted summarised.

http://fmforums.com/forum/showpost.php?post/313019/

--sd

[innodat]

Good point. Might be too slow.

The reason I pointed in this direction is, because it sounded like he needs the data in

A) the remote table, and

: on a regular layout in browse mode, as opposed to a report.